Forum Discussion
Place a refresh button in PBI
- 1 year ago
It's a VBI (Very Bad Idea). Refresh requests are asynchronous, so the user will not refresh anything, they will only request a refresh. There is no feedback when the refresh completed and if it was successful. You are also risking multiple users attempting this at the same time and the Power BI service then respoingding with a 429.
It is possible to do a rudimentary data write back with a PowerApps visual and a Direct Query data source. But the UX is not very good.
- Anonymous1 year ago
Hi rod_puente,
Thank you for reaching out in Microsoft Community Forum.
Thank you lbendlin for the helpful response.
Please follow below steps to Add a Button in Power BI to Refresh Data (for Service use):
1.Please create a power automate flow using below steps
->Go to Power Automate, create an instant cloud flow triggered by a Power BI button and Add the "Refresh a dataset" action.
2.Add the Power Automate Visual in Power BI
->Drag the Power Automate visual into your report and Link it to your refresh flow.3.Rename it (e.g., “Refresh Now”) and format it like a button.
4.Share the report. When users click the button, it triggers a dataset refresh.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
It's a VBI (Very Bad Idea). Refresh requests are asynchronous, so the user will not refresh anything, they will only request a refresh. There is no feedback when the refresh completed and if it was successful. You are also risking multiple users attempting this at the same time and the Power BI service then respoingding with a 429.
It is possible to do a rudimentary data write back with a PowerApps visual and a Direct Query data source. But the UX is not very good.