Power BI - Getting Data
Why might using DirectQuery mode with multiple data sources in one Power BI report cause performance issues?
Why might using DirectQuery mode with multiple data sources in one Power BI report cause performance issues?
hard📝 Conceptual Q10 of 15
Step-by-Step Solution
Solution:
Step 1: Understand DirectQuery behavior with multiple sources
DirectQuery sends live queries to each data source when visuals refresh.Step 2: Analyze performance impact
Multiple sources mean multiple live queries, increasing load time and slowing report.Final Answer:
Because each query sends live requests to different sources, increasing load time -> Option BQuick Check:
Multiple DirectQuery sources increase live query load [OK]
Quick Trick: Multiple DirectQuery sources cause multiple live queries [OK]
Common Mistakes:
- Thinking DirectQuery caches all data locally
- Assuming automatic query merging
- Believing relationships are disabled
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes