🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate10 / 150
Question 10 of 150
You are building a composite semantic model in Power BI Desktop. A large fact table uses DirectQuery against a Fabric warehouse. A shared Date dimension is used both to filter the DirectQuery fact table and to filter a smaller Import-mode fact table for a different report page. You want cross-highlighting and relationship filtering to work efficiently against both fact tables without generating unnecessary queries back to the source. Which storage mode should you set on the Date dimension table?
Reviewed for accuracy · Report an issueNext question