Forum Discussion

duybachhpvn's avatar
duybachhpvn
Frequent Visitor
4 years ago

Script to automate single table in a dataset using XMLA Endpoint

Hi,

 

By using XMLA Endpoint, I was able to access my PowerBI Dataset in the Service using SQL Management Studio, which allowed me to process/refresh a single table in my dataset. The Script to refresh is as below

 

 

 

{
  "refresh": {
    "type": "full",
    "objects": [
      {
        "database": "BE Standard Cost Actual Reporting",
        "table": "Flash_Volume"
      }
    ]
  }
}

 

 

 

Now, if I want to schedule SQL Studio, or using any other tool to schedule this code to run in SQL Studio every 10 minutes, how can I do it?

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    You can create a SSIS package for this, you can run a scheduled powershell script, you can use Power Automate to run a HTTP POST request.  What's your preference?

     

    Note:  The tricky part with all of these will be to obtain the auth token.

    • duybachhpvn's avatar
      duybachhpvn
      Frequent Visitor
      4 years ago

      Hi lbendlin , Do you have some resources online that I can refer to for each of those options you mentioned?

  • alexrobe_RHI's avatar
    alexrobe_RHI
    Frequent Visitor
    4 years ago

    Have you ever succeded in solving your requirement? Maybe even an elegant way with PowerAutomate?
    Thanks!