Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

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 da...
  • v-zhangti's avatar
    2 years ago

    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.