XMLA Endpoint Script-Scheduling

[Anonymous]

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 ?

[v-luwang-msft]

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

[lbendlin]

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.

[Anonymous]

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