Forum Discussion
Anonymous
3 years agoNot applicable
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.
1 Reply
- marcosvin
Resolver II
Hi!
This blog post "Data - Marc" explains one possibility to do this using Azure Data Factory: