How to Enforce Full Refresh on a Dataset which is published with Incremental Settings

[preetjawaria]

Hi Team,

We have a cube file published over Power Bi Service with Incremental settings, there are scenarios where our history data is changing weekly and we want our dataset to be updated once in a week, which is possible through Full Refresh else we are good with incremental refresh for rest of the days.

Is there any way possible to handle this scenario ?

[nilendraFabric · Accepted solution]

Hi @preetjawaria 

Use the XMLA Endpoint for Full Refresh
Power BI datasets with incremental refresh are partitioned into historical and incremental partitions. To perform a full refresh on such datasets, you can use the XMLA endpoint to override the incremental refresh policy temporarily:
• Steps:
1. Enable the XMLA endpoint for your Power BI workspace (requires Premium or Premium Per User licensing).
2. Use a tool like Tabular Editor, SSMS (SQL Server Management Studio), or a custom script to execute a TMSL (Tabular Model Scripting Language) command.
3. In your TMSL script, set `applyRefreshPolicy` to `false` for the full refresh.
• Example TMSL Command:

{
"refresh": {
"type": "full",
"applyRefreshPolicy": false,
"objects": [
{
"database": "YourDatasetName",
"table": "YourTableName"
}
]
}
}

Adjust Incremental Refresh Policy Temporarily
If you prefer not to use XMLA:
• Open your dataset in Power BI Desktop.
• Temporarily disable incremental refresh by removing or modifying the `RangeStart` and `RangeEnd` parameters in Power Query.
• Publish the dataset back to Power BI Service and perform a full refresh.
• Re-enable incremental refresh by reconfiguring these parameters and republishing.
This method is less efficient as it involves republishing your dataset

Hope this helps. 
Please accept the answer if this is helpful 

Thanks