Pro - Refresh individual tables in Service

[joshua1990]

Hi experts!

Is there any chance to refresh individual or just 1 table in a published dataset?

I have a really huge dataset that has a manuel little excel file that should be refreshed just once a day.

Is it possible to refresh just this table?

Maybe with using Power Automate?

It is related to a Pro Workspace

[otravers]

The Power BI Refresh Dataset REST API supports table-level refreshes. Unless that was added recently, I don't recall seeing this in the UI actions in Power Automate, so you'll have to call the API via a custom connector:

https://docs.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh

[joshua1990]

Thanks a lot! I just saw this feature is not avialable for PRO Workspaces.

[otravers · Accepted solution]

You're correct, I'm sorry somehow I missed that because you did specify you're using Pro.

For other people interested in calling this API from Power Automate, Chris Webb just posted a walkthrough:

https://blog.crossjoin.co.uk/2022/08/14/calling-the-power-bi-enhanced-refresh-api-from-power-automat...