Forum Discussion

rod_puente's avatar
rod_puente
Icon for Helper I rankHelper I
1 year ago
Solved

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...
  • lbendlin's avatar
    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.

  • Anonymous's avatar
    Anonymous
    1 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.