Question
A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow.
You need to use the dataflow in a report. The solution must meet the following requirements:
- Minimize online processing operations.
- Minimize calculation times and render times for visuals.
- Include data from the current year, up to and including the previous day.
What should you do?
- A. Create a dataflows connection that has DirectQuery mode selected.
- B. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset.
- C. Create a dataflows connection that has Import mode selected and schedule a daily refresh. Correct
- D. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.
Explanation
Importing the dataflow caches the data in the model, so visuals calculate and render from memory and no queries run online at report time. Data only needs to be current up to the previous day, so a daily scheduled refresh is enough. DirectQuery options send a query for every visual interaction, increasing online processing and render times, and an hourly refresh adds processing the requirement does not need.
