Question
You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily.
You create a Microsoft Power BI semantic model named Model1 that uses the CSV files as a data source. You configure incremental refresh for Model1 and publish the model to a Premium capacity in the Fabric tenant.
When you initiate a refresh of Model1, the refresh fails after running out of resources.
What is a possible cause of the 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. Correct
- E. The data type of the column used to partition the data has changed.
Explanation
Incremental refresh relies on the RangeStart/RangeEnd filter being pushed to the source. When query folding does not occur, the mashup engine retrieves all rows from the source and applies the filter locally, which can make the refresh run out of resources and defeats the purpose of incremental refresh. Query folding occurring is the desired behavior, Only refresh complete days just aligns the refresh window to whole days, and a read-only XMLA endpoint does not affect refreshes started in the service. A changed data type would cause an error rather than resource exhaustion.
