Refreshing all datasets in a PowerBi workspace using PowerAutomate

(0) Share

Report

Posted on by GrégoireSetics

Hello, I have been meaning to automate the refresh of all datasets of my workspace (27) when a dataflow finishes updating. I haven't found a better way than doing each update by hand using the 'Refresh dataset' connector. I also have tried using python in a dataset to trigger the other refreshes using the API.

But I got no luck so far. Is there no way to actually just refresh all the datasets using only power automate?

Thanks

All responses (1)

Answers (0)

lbendlin 7,794 Super User 2025 Season 1 on at

Like (0)

Report

Re: Refreshing all datasets in a PowerBi workspace using PowerAutomate

Technically this is easy. Create an array with all dataset IDs and then iterate over that array to initate a dataset refresh for each.

However, this will backfire as your Power BI capacity has limited renderers available ( six on a P1, for example) so your 27 requests will either be queued (best case) or ignored (worst case). So it is imperative to add a delay in your loop. Better yet - use the enhanced refresh API and wait for one refresh to finish before starting the next.