Forum Discussion
Helper IIHow to automate custom partitioning dataset refresh
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.
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.
Super UserYou are describing the functionality of Power BI Incremental Refresh. Any particular reason for not using it? It does the partition management for you automatically. All you need to provide is a datetime value for the partition boundary filter.
Helper IIThanks lbendlin for your quick response.
Why we are not using incremental refresh is, we have lot of power query applied steps for that fact table and due to that it doesn't support for query folding. To leverage incremental refresh along with premium, table should support query folding other wise parameters won't be enable while applying the incremental refresh in PowerBI desktop level.
Hence we partitioned big fact using tabulaer editor and tried refreshing each partition using SSMS and it tooks very very lest time when compared to my original dataset.
So now i am looking to refresh the partitions automatically instead of manully in SSMS. So please suggest the relavent solutions if any. Thanks in adavance
- lbendlin
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.
SaiTejaTalasila