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?
A . Query folding is not occurring.
B . You selected Only refresh complete periods.
C . The data type of the column used to partition the data changed.
D . A filter is missing on the report.
Answer: A
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.
Reference: https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/
Leave a Reply