Security, Compliance, and Identity Fundamentals Flashcards

Master key concepts with interactive flashcards

Need help staying focused? Foci helps you manage tasks and focus while you study.

Card 1 of 10

0 known

Prepare the data

Question

What is the difference between DirectQuery, Import, and DirectLake in Power BI?

Click to reveal answer

Prepare the data

Answer

**Import**: Copies data into the in-memory VertiPaq engine at refresh time. Fastest query performance but requires scheduled refresh. **DirectQuery**: Queries the source database live on every visual render. Always current but slower per query. **DirectLake**: Fabric-native mode that reads Parquet/Delta files directly from OneLake without importing, combining real-time freshness with VertiPaq speed.

Click to show question

Tip: Use ← → arrow keys to navigate, Space to flip card