DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

By Microsoft · Question Mode

QuestionQ14

Implement and manage semantic models

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.
  • E The delta type of the column used to partition the data has changed.
Explanation

Incremental refresh relies on query folding so that Power Query can push the date-range filtering back to the source; flat files such as CSV generally do not support folding, so every partition's data must be pulled in full and processed in memory by the Power BI engine. With 30 files refreshed this way, the capacity runs out of memory/CPU resources long before the refresh finishes, which is the classic symptom of a non-folding incremental refresh.

Community Discussion

No comments yet. Be the first to start the discussion!