Explanatory Question

What is DirectQuery Mode?

👁 0 Views

📘 Detailed Answer

🕒 Easy to Read

Read the answer carefully and go through the related questions on the right side to improve your understanding of this topic.

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.

How to use this answer better

First read the answer fully, then try to explain it in your own words. After that, open a few related questions and compare the concepts. This method helps you remember the topic for a longer time and improves exam preparation.