Forum Discussion
XMLA Endpoint Script-Scheduling
Hi Experts,
I have Premium capacity Power BI and I have published SalesDataset on it.
I used XMLA Endpoint script to process it but I follow a manual process, I execute XMLA endpoint script via SSMS (on Query window).
Question/Suggestion:
I need to Schedule this process of executing XMLA endpoint script of SalesDataset, Please let me know what possibly can be done to achieve this ?
3 Replies
- v-luwang-msftCommunity Support
Hi Anonymous ,
You want use XMLA Endpoint Script to refresh dateset scheduly ?You can see the below article , Wish it is helpful for you!
XMLA-BASED PBI DATASET REFRESH AUTOMATION: https://insightsquest.com/2021/02/21/xmla-based-pbi-dataset-refresh-automation/
Best Regard
Lucien Wang
- lbendlinSuper User
if it is just a standard reprocessing then the REST API might be a simpler way to achieve what you want. If you need finer control (for example to process a particular partition) then you can use SQLCMD or similar.
- AnonymousNot applicable
REST API Process entire Dataset on Service , I do not want to process all the Facts on Daily Basic ( which Inrease by Dataset processing time) ,hence want to process specifics tables using XMLA Endpoint , which I Execute manually, Looking for its scheduling Option