How to automate custom partitioning dataset refresh

Hi lavankumar1989a 

lbendlin Thank you very much for your prompt reply and here allow me to share some of it.

 Utilize the XMLA endpoint for advanced refresh and partition management. 

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

This method requires your Power BI dataset to be hosted in a workspace assigned to a Premium capacity, as XMLA endpoints are a feature of Power BI Premium.

If your Power BI service is hosted on Azure, you can use Azure Automation to create runbooks that refresh partitions on a schedule.

Regards,

Nono Chen

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

Query folding is NOT a requirement for incremental refresh. It is very desirable, but incremental refresh will also work without it.

Anyway - you can run your XMLA script from anywhere, including Powershell or Power Automate.

Hi lavankumar1989a ,

You can refer this -

https://www.fourmoo.com/2022/01/12/using-the-power-bi-async-rest-api-to-refresh-a-partition-with-power-automate-using-an-https-url/

I hope it will be helpful.

Thanks,

Sai Teja