Power Automate Button stuck on triggering in when embedded in public website

[HeirsPowerBi]

I have a powerbi report with a power automate button that triggers a flow, 

it works fine when i publish and click the button from the powerbi service, how ever when i embed the report in a public website the button just stays stuck on triggering and nothing happens at all.

Kindly assist

[v-yanjiang-msft · Accepted solution]

Hi @HeirsPowerBi ,

Here are the limitations of trigger flows from Power BI report. The user running the flow within the Power BI report needs to have permissions to run the flow.

More information refer to this article:Trigger a flow from any Power BI report - Power Automate | Microsoft Docs

Best Regards,
Community Support Team _ kalyj

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

[sdumper1967]

This is a HUGE limitation if your sharing a report with say a 1000 or more users then you have to grant them read only permissions to each flow and when you do they get an email for each grant. So say if your report has 10 flow buttons were looking at 10,000 emails granting permission. Realy really really stupid and poor experience.

[aj1973]

Hi @HeirsPowerBi 

You said Public website! meaning you used the Public URL from Power bi service to embed it into the website? if that's the case then it won't work. Power platform(Power Apps, Power automate, AI, Chat bots) are for private use only meaning you can't share sensitive data publicly, you would need different type of license for it.