PL-300 · Question #112
You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh. From powerbi.com, you deploy the dataset and several related reports to Microsoft Po
The correct answer is A. Query folding is not occurring.. The Power BI service partitions data based on date range. This is what enables only certain partitions to be refreshed incrementally. To make this work, the partition filter conditions are pushed down to the source system by including them in the queries. Using Power Query termin
Question
You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh. From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity. You discover that the dataset refresh fails after the refresh runs out of resources. What is a possible cause of the issue?
Options
- AQuery folding is not occurring.
- BYou selected Only refresh complete periods.
- CThe data type of the column used to partition the data changed.
- DA filter is missing on the report.
How the community answered
(20 responses)- A80% (16)
- B5% (1)
- C5% (1)
- D10% (2)
Explanation
The Power BI service partitions data based on date range. This is what enables only certain partitions to be refreshed incrementally. To make this work, the partition filter conditions are pushed down to the source system by including them in the queries. Using Power Query terminology, this is called "query folding". It is not recommended that incremental refresh is used when the required query folding cannot take place. https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/
Topics
Community Discussion
No community discussion yet for this question.