cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amilanien
Regular Visitor

Power Automate Button in Power BI does not work when embedded in SharePoint

I have a Power Automate Button in a Power BI report that exports data to a CSV file in OneDrive.  When clicked in the Power BI interface it works perfectly.  The button says Triggering and then Triggered and the flow is completed. 

 

The Power BI Report is presented to users embedded in a SharePoint Online page.  When the Power Automate button is clicked on the embedded report the Button switches to say Triggering and hangs there and never processes.  This state never resolves and the flow is not kicked off.  What are we doing wrong? 

4 REPLIES 4
Thiago__Lima
Regular Visitor

Not shure if this is a limitation on Sharepoint, but when using Power Automate buttons on Power BI you need to share the flow with the people that need to run it, or with everyone on your company (if you have a group set up like that). Also, you could try to set the Sharepoint as owner and see if it works (check the image bellow).

 

Thiago__Lima_0-1680099076913.png

 

gsheeley
New Member

I have exactly the same issue.

My flow works perfectly from Power BI Desktop and from the Power BI Web Interface too. However when clicking the button from the report embedded on a Sharepoint page it hangs. The button text changes to "Triggering" and just sits there. 

 

Looking at the 28-day run history of the flow, I see it has not even started.

 

This is super disappointing as my users only access the report via the embedded Sharepoint version, therefore in my scenario this new functionality is of no use for us. Any update, posting this in March 2023

David_Morris
Frequent Visitor

I also have the same problem. Has anybody found a solution?

 

My flow works perfectly from Power BI Desktop and from the Power BI Web Interface too. However when clicking the button from the report embedded on a Sharepoint page it hangs. The button text changes to "Triggering" and just sits there. 

 

Looking at the 28-day run history of the flow, I see it has not even started.

 

This is super disappointing as my users only access the report via the embedded Sharepoint version, therefore in my scenario this new functionality is of no use for us.

 

Has there been any further movement or acknowledgement of this since the previous post in September 2022?

Cheetah
Helper I
Helper I

I have the same problem. not other users but myself as the owner of the flow, cannot successfully triger the flow when the report is embedded to a Sharepoint, while in PowerBI sever it works fine.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Kudoed Authors