Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Have you ever succeded in solving your requirement? Maybe even an elegant way with PowerAutomate?
Thanks!
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?
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
30 | |
20 | |
19 | |
13 | |
13 |
User | Count |
---|---|
28 | |
18 | |
18 | |
16 | |
14 |