🔥 3-day streak
Microsoft Power BI Data Analyst8 / 205
Question 8 of 205

You maintain a Power BI model in DirectQuery mode over an Azure SQL Database. The model has a single many-to-one relationship between a large Sales fact table and a Product dimension. You have verified that every ProductKey in Sales exists in the Product table (the source enforces a foreign-key constraint). Query performance on visuals that combine Sales and Product is slower than expected. Which relationship setting should you enable to improve DirectQuery performance while keeping results correct?

Reviewed for accuracy · Report an issueNext question