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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors