Free Preparation Discussions
MENU
Microsoft Exam DA-100 Topic 5 Question 47 Discussion
Topic #: 5
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?
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/
Currently there are no comments in this discussion, be the first to comment!