🔥 3-day streak
Microsoft Power BI Data Analyst18 / 205
Question 18 of 205

You are building a Power BI model with a large fact table (Sales) that stays in DirectQuery mode against an Azure SQL Database for near-real-time reporting. A small Product dimension table is used both in slicers and in relationships with the DirectQuery fact table. Slicer interactions are slow because every selection sends a query to the source. You want fast slicer responses while still supporting efficient joins to the DirectQuery fact table. Which storage mode should you set on the Product table?

Reviewed for accuracy · Report an issueNext question