✏️ Explanatory Question

What is DirectQuery Mode?

👁 2 Views

📘 Detailed Answer

🟢 Easy

💡

Answer with Explanation

DirectQuery does not import data into Power BI.

Every user interaction sends queries directly to the source database.

Advantages:

Near real-time reporting.
No dataset size limitations.
Data remains in source system.

Disadvantages:

Slower performance.
Limited DAX support.
Dependent on source system speed.