Forum Discussion
Helper IPower BI service Incremental refresh + XMLA refresh
Hi,
Let's say we have a large 'Orders' table in our dataset, can I define an incremental refresh policy to archive five years of data and refresh only the last six months for this table, and we would then schedule the Power BI service to refresh every 30 minutes, plus, once a day, we would refresh the entire 'Orders' table through the XMLA endpoint, either via a PowerShell script or Analysis Services? Would refreshing the entire dataset disrupt the incremental refresh policy?
Thanks a lot!
Hi hoosha_11 ,
First of all, many thanks to for your very quick and effective replies.
Based on my learning, it is possible to define an incremental refresh policy and refresh the Orders table through the XMLA endpoint.
Firstly, configure incremental refresh and set refresh ranges.
Then, use XMLA to refresh one table or partitions.
You can also view the following document to learn more about how to fix the error.
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- lbendlin
Super User
no, you can refresh individual partitions independently. Access conflicts (for example when partitions are about to be consolidated) will be resolved by the service.
Hi hoosha_11 ,
First of all, many thanks to for your very quick and effective replies.
Based on my learning, it is possible to define an incremental refresh policy and refresh the Orders table through the XMLA endpoint.
Firstly, configure incremental refresh and set refresh ranges.
Then, use XMLA to refresh one table or partitions.
You can also view the following document to learn more about how to fix the error.
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
