Power Automate Button Not Appearing

[mancfoo]

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 fine for several weeks and has looked the same across Desktop, Teams and browser.

I haven't changed anything on the report but today we're finding that the actual button to run the flow is just not appearing in Teams or the browser. It still appears fine in Desktop. It's a blank space in Teams (though cursor changes to a hand when hovered over):

If I open in a browser I see the following:

The button has never had any fields in the 'Power Automate data' field in PowerBI but now it's like it expects something in that field to display the button? Can anybody help?

Thanks,

Matt

[EvgeniAb]

Just to recap

Issue: The Power Automate visual (native in Power BI) does not appear or function when a report is embedded in SharePoint, Teams, etc. The button is visible in Power BI Desktop or on the Power BI Service.

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.

[Mullet1]

Not sure if this is a fix but here is how I was able to get the buttons back.

I had to open the desktop version of powerbi. from the Home page I clicked on the report I wanted to open but not the pbix file on my harddrive. I opened the one that was located in Power BI workspace location

This directly launched into a browser and the buttons had re appeared.

I then went back to the original tab that had my workspace open and it still did not have the buttons even after I refreshed so I closed that tab. I opened a new tab in my browser and went to Powerbi dashboard and opened the report and the buttons were also visible. 

Not sure how but seems to be working now.

[jl1818]

I have same issue from this week 19-aug-2024. 

[Mullet1]

I recently had a similar issue arrise on a report in the powerbi browser. On mine I discovered that the visual was still there however the trigger button appears to be missing. Changing the fill color and text color does not make the button re appear.

The trigger button is there and works in the desktop version but when published to the browser the visual is presant but the trigger button is not.

Anyone else had this issue?

[EvgeniAb]

We are experiencing the same issue in two separate reports for a customer. Most probably it is related to a recent MS update.

Solved it via HTTP request.

We replaced a trigger with Power automate button with a HTTP GET call to start the flow. Added it to a random empty botton to the canvas.

(downside - it is openning an empty page from the request, but refrehs is working) 

[lbendlin]

can you pinpoint when it started happening?

[EvgeniAb]

Power Automete (Flow) button gone bad today on Monday. 

It doesn't show when the report is embedded to SharePoint. (desktop and service are fine) 

[mancfoo]

Hi @lbendlin ,

I'm using Power BI Desktop version 2.130.930.0 (June 2024) and the report and power automate button were working fine on 13th August but did not work on 15th August or since. Just to clarify, if I open the report in Desktop I can see the button and I can click on it and have confirmed that the power automate flow has run this way today. However, when I or others access the published version of the report via Teams the button is invisible.

Thanks,

Matt

[v-stephen-msft]

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.

[Mullet1]

I tried republishing and that did not fix the trigger button. 

[mancfoo]

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]

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? 

[Mullet1]

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.

[EvgeniAb]

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.