Forum Discussion
Power Automate Refresh Button with PowerBI Report
Hi jr2314,
yes, multiple users hitting your Power Automate button at the same time can cause issues—but splitting users across two workspaces is not the right fix and won’t reliably prevent it as the source remain the same.
To Fix this, you can create a control table in a shared capacity (Sharepoint etc.)
Isrefreshing = True/False
1. Then create a flow logic like if isrefreshing is true then throw a msg. to user to try after some time and if it's false then run the refresh after the refresh is finished set isrefreshing back to false.
2. instead of user to hit refresh again you can create a queue for the users, and again use above login but this time instead of throwing an error, they see a msg. that the request is in queue, as soon as the first task is over (isrefreshing = false) then the second task is performed
this will avoid cocurrent refreshed and overload on the datasource/API.
better performance
no refresh failures
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!Hi jr2314,
You can add wait for 30 seconds (Delay = 30 seconds) and to flag check Status = Completed OR Failed in between the flow and only move forward once you have any of these status and show user a message accordingly
grazitti_sapna Thank you I've created a control table with a default status of false. This will seem to do the trick. My only issue is that this flow only triggers the dataset refresh and doesn't actually know when the refresh is complete. So it's basically running it, because the default is false it changes it to true, then refreshes the dataset, then changes it back to false. Then sends a teams message to the user saying it was successful, but when I look in PowerBI service the semantic model is still being refreshed. I guess I'm looking for a way to know the refresh was successful first before sending a message that it's been completed.
Hi jr2314,
You can add wait for 30 seconds (Delay = 30 seconds) and to flag check Status = Completed OR Failed in between the flow and only move forward once you have any of these status and show user a message accordingly