Question

You maintain a large enterprise semantic model in a Fabric Premium capacity workspace. The model has a fact table partitioned by year, and only the current year's partition needs refreshing daily while historical partitions remain static. The dataset's scheduled refresh currently reloads all partitions, causing long refresh times and high memory usage. You want to refresh only the current-year partition programmatically without altering the historical data. Which approach should you use?

Accepted Answer

Connect to the workspace XMLA endpoint using SQL Server Management Studio or Tabular Editor and issue a TMSL processObject command targeting only the current-year partition.

Answer

Configure incremental refresh policy in Power BI Desktop and republish, then rely on the standard scheduled refresh to detect changes.

Answer

Use the Power BI REST API refreshes endpoint with a full refresh type to reprocess the model.

Answer

Enable the XMLA endpoint in read-only mode and trigger a refresh from the dataset settings page in the Fabric portal.