Schedule refresh of specific tables (not whole dataset)

Anonymous — Mon, 19 Jun 2023 08:59:22 GMT

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.

Re: Schedule refresh of specific tables (not whole dataset)

marcosvin — Mon, 19 Jun 2023 19:57:06 GMT

Hi!

This blog post "Data - Marc" explains one possibility to do this using Azure Data Factory:

Automate Power BI single table refresh using Azure Data Factory and Azure Automation – Data – Marc (data-marc.com)

topic Schedule refresh of specific tables (not whole dataset) in Developer

Schedule refresh of specific tables (not whole dataset)

Re: Schedule refresh of specific tables (not whole dataset)