DP-500 · Question #59
Based on a query dependency diagram, which action will reduce data refresh times for this model?
The correct answer is B. Replacing the Orders query with a dataflow. Replacing a query with a dataflow can significantly reduce data refresh times by allowing the dataflow to pre-process and store data in Azure Data Lake Storage Gen2, which Power BI can then consume more efficiently.
Question
Options
- ADuplicating the Orders query instead of referencing the query
- BReplacing the Orders query with a dataflow
- CUsing Table Buffer in the Orders query
How the community answered
(35 responses)- A11% (4)
- B83% (29)
- C6% (2)
Why each option
Replacing a query with a dataflow can significantly reduce data refresh times by allowing the dataflow to pre-process and store data in Azure Data Lake Storage Gen2, which Power BI can then consume more efficiently.
Duplicating the Orders query instead of referencing it would likely increase refresh times, as the query logic would be executed multiple times, once for each duplicate, rather than once for a single referenced query.
Replacing a query with a dataflow allows for data transformation and storage outside of the Power BI dataset refresh process. Dataflows can be refreshed independently, and the transformed data stored in Azure Data Lake Storage Gen2 can be consumed by the Power BI model, significantly reducing the refresh burden on the report itself and improving refresh times.
While Table.Buffer can sometimes improve performance by caching intermediate table results, its impact is often localized and may not provide a significant model-wide refresh time reduction compared to the architectural benefit of dataflows, and it can increase memory consumption.
Concept tested: Power BI dataflow benefits for refresh optimization
Source: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction
Topics
Community Discussion
No community discussion yet for this question.