Forum Discussion
Place a refresh button in PBI
Dear All!
Pls I need your help, How can I add a button in PBI that allows me to update a specific table, and then use it in PBI Service?
I have users who ask me for a button to update a piece of data whenever they need it, without waiting for a scheduled update.
Regards
Rodrigo Puente
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.
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.
6 Replies
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.
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.Hi rod_puente,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Thank you,
Pavan.Excelent.
Tks very much!
Regards
Rodrigo Puente
Hi rod_puente,
Thank you for reaching out in Microsoft Community Forum.
We hope your issue has been resolved. If yes,please mark it as "Accept as Solution" and give it a 'Kudos' if it was helpful. This will help other members find it more easily.
Regards,
Pavan.Hi rod_puente,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Thank you,
Pavan.
