Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
duybachhpvn
Frequent Visitor

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?

3 REPLIES 3
alexrobe_RHI
Frequent Visitor

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

lbendlin
Super User
Super User

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.

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.