You want to create a Power BI report that always shows the latest sales data from SQL Server without importing all data each time. Which connection mode should you choose and why?

hard📝 Scenario Q15 of 15

Power BI - Getting Data

ADirectQuery, because it imports all data once

BImport, because it loads all data once and never updates

CImport, because it queries live data on demand

DDirectQuery, because it queries live data on demand

Step-by-Step Solution

Solution:

Step 1: Understand Import vs DirectQuery
Import loads data once; DirectQuery queries live data each time.
Step 2: Choose mode for latest data without full import
DirectQuery fits because it fetches current data without importing all.
Final Answer:
DirectQuery, because it queries live data on demand -> Option D
Quick Check:
Latest data without import = DirectQuery [OK]

Quick Trick: Use DirectQuery for live data, Import for snapshot [OK]

Common Mistakes:

Confusing Import with live querying
Choosing Import when data freshness is needed
Misunderstanding DirectQuery behavior

Master "Getting Data" in Power BI

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More Power BI Quizzes

You want to create a Power BI report that always shows the latest sales data from SQL Server without importing all data each time. Which connection mode should you choose and why?

Step 1: Understand Import vs DirectQuery

Step 2: Choose mode for latest data without full import

Final Answer:

Quick Check:

Want More Practice?