You’re offline. This is a read only version of the page.
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
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.
Share
Report
All responses (
Answers (
8,716
