Answer-first summary for fast verification
Answer: Query folding is NOT occurring.
Query folding is not applicable with CSV files, which rules out options A and D. The failure is likely due to the process of applying all required data transformations using the Power Query engine, which can be resource-intensive without query folding. Query folding helps to push down transformations to the source query for efficiency, but since CSV files do not support this feature, the entire transformation process has to be handled by the Power Query engine, leading to resource exhaustion.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You oversee a Fabric tenant that houses 30 CSV files stored in OneLake, which receive daily updates. To leverage this data, you create a Microsoft Power BI semantic model named Model1, using these CSV files as its data source. You've also configured incremental refresh for Model1 and published this model to a Premium capacity within the Fabric tenant. However, when you attempt to refresh Model1, the process fails due to resource exhaustion. What could be a plausible reason for this failure?
A
Query folding is occurring.
B
Only refresh complete days is selected.
C
XMLA Endpoint is set to Read Only.
D
Query folding is NOT occurring.
E
The delta type of the column used to partition the data has changed.
No comments yet.