Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Schedule refresh of specific tables (not whole dataset)

Hi,

I want to schedule refresh of part of my Power BI dataset (not all tables but only a few of them). From SSMS I can run the following JSON script that does exactly what I want:

 

{
"refresh": {
"type": "full",


"objects": [
{
"database": "XXXl",
"table": "TableA"
}
]
}
}

 

But what is the easiest way to schedule this if I want it to run daily?

 

I have tried the "run a json query against a dataset" module in Power Automate but did not get it to work.