Power BI - Getting Data
If you connect Power BI to SQL Server using DirectQuery mode and the SQL table has 2000 rows, how many rows does Power BI store locally?
If you connect Power BI to SQL Server using DirectQuery mode and the SQL table has 2000 rows, how many rows does Power BI store locally?
medium📝 Formula Result Q5 of 15
Step-by-Step Solution
Solution:
Step 1: Understand DirectQuery mode data storage
DirectQuery mode does not import data; it queries the source live.Step 2: Local data storage in DirectQuery
Power BI stores no data locally; all data remains in SQL Server.Final Answer:
0 rows -> Option CQuick Check:
DirectQuery stores no local data = 0 rows [OK]
Quick Trick: DirectQuery queries live, stores no data locally [OK]
Common Mistakes:
- Assuming DirectQuery imports data
- Thinking partial data is cached locally
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes