Forum Discussion

mancfoo's avatar
mancfoo
Regular Visitor
2 years ago

Power Automate Button Not Appearing

Hi,   I created a Power Automate button on a PowerBI Desktop report so that user can refresh the dataset manually. They access the report via a PowerBI tab in a Teams channel. This has been working...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mancfoo ,

 

The workaround you can try here is to republish a local report to Power BI Service and see if the button exists.

You'll also need to check that your Power Automate flow is set up correctly.

There is also the possibility that someone else has edit access to this report in Power BI Service, and that someone may have misoperated in the Service and the button was removed.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

mancfoo's avatar
mancfoo
Regular Visitor
2 years ago

Thanks for these suggestions. I am the only person with edit access to the report so the button is definitely still there - I've confirmed it is visible and working in Desktop today so the flow is also working (it's really just a very basic flow to manually refresh the dataset).

 

I tried to access the report via the Power BI service at app.powerbi.com (which I didn't try last week) and the button does correctly display and work there. However, it still does not display or function when accessed via a shared link (where it displays a space saying select or drag fields to populate the visual) or as a tab in the Teams channel (where it's just an empty space).

  • cfpbi_24's avatar
    cfpbi_24
    New Member
    1 year ago

    We are facing the same issue. Have you found any solutions? Do you know if this is a known MS bug they're working on? 

    • EvgeniAb's avatar
      EvgeniAb
      Frequent Visitor
      1 year ago

      Solution: Hide the Power Automate visual and replace it with a regular shape-button in Power BI. Add a trigger to call a GET HTTP request to the Power Automate flow you want to run. Once the "call HTTP" action is created and saved, copy the URL and set it as the action for the new shape-button. This workaround resolves the issue with the missing button.

      Downside: When the button is clicked, a new empty tab opens, which users will need to close.

      • ochavez29's avatar
        ochavez29
        Regular Visitor
        1 year ago

        Hi EvgeniAb , I'm facing this very issue and tried to do what you suggest, but I can't figure out how to call my PowerBI button triggered flow from the http request flow, can you please explain to me how to do that?

        I will really appreciate it.

    • Mullet1's avatar
      Mullet1
      Regular Visitor
      1 year ago

      A work around I have found is:

      1) open a new tab in my browser

      2) go to powerbi.com

      3) open the report I need from the main dashboard

       

      When the page opens the powerautomate button is back. however in a day or two it will be gone again and I have to start a new tab with powerbi again.