Power BI Partition Refresh Automated (with incremental set up configured)

[Anonymous]

Hi, 

I have a fact table on which I have set up an incremental refresh for refreshing the last 60 days' data from the current date. Refresh from the service only enables refreshing the last 60 days, But I want my historical partitions to be auto-refreshed on a weekly basis instead of manually refreshing each partition. 

Please help me with the approach and power shell script needed for this.

[v-zhangti · Accepted solution]

Hi, @Anonymous 

After configuring incremental refresh, then configure scheduled refresh or manual refresh, both of which follow the rules of incremental refresh. If you want to refresh all historical partitions, you can use the XMLA endpoint to do so.

If your dataset is on a Premium capacity with an XMLA endpoint enabled, incremental refresh can be further extended for advanced scenarios. For example, you can use SQL Server Management Studio to view and manage partitions, bootstrap the initial refresh operation, or refresh backdated historical partitions.

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.