Power BI - Getting Data
You connect Power BI to SQL Server using Import mode and load a table with 1000 rows. After refreshing, how many rows will Power BI show if 50 new rows were added in SQL Server?
You connect Power BI to SQL Server using Import mode and load a table with 1000 rows. After refreshing, how many rows will Power BI show if 50 new rows were added in SQL Server?
medium📝 Formula Result Q4 of 15
Step-by-Step Solution
Solution:
Step 1: Understand Import mode behavior
In Import mode, Power BI loads data into its own cache and refresh updates this cache.Step 2: Effect of refresh on data rows
Refreshing reloads the entire table, so new rows added in SQL Server appear in Power BI.Final Answer:
1050 rows -> Option AQuick Check:
Import mode refresh updates data = 1050 rows [OK]
Quick Trick: Import mode refresh reloads all data including new rows [OK]
Common Mistakes:
- Assuming refresh does not update new rows
- Confusing Import with DirectQuery mode
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes