Published Report Functionality Limited

[swhistance]

I have a multi page report which is needed to be shared outside my organisation. We have our own reporting portal which enforces sign in for the audience that require access to the report.

The report has a button which triggers a Power Automate flow

The Report is held in a Power BI Embedded Workspace, if I embed the report (website or portal) the full functionality is only available to PowerBI users, if I publish to web the PowerAutomate flow is not available. 

How do I use the portal authentication process to allow for the all the report functionality?

[Natarajan_M · Accepted solution]

Hi @swhistance 

The Power Automate visual is officially not supported in embedded analytics or Publish to Web scenario it requires authenticated Power BI user context.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual

you can check on the below approach : 

1. Use "Embed for Your Customers" (App Owns Data) : your portal authenticates via a service principal. External users don't need Power BI licenses.
Ref: https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-sample-for-customers

2. For the Power Automate button : replace the native visual with a regular shape-button that triggers the flow via an HTTP GET request. Set up your Power Automate flow with an HTTP trigger, copy the URL, and assign it as the button's web URL action.

3. You'll need a Power BI Embedded (A SKU), Premium (P/EM SKU), or Fabric (F SKU) capacity for production.

This way your portal handles user auth, the service principal handles Power BI auth, and the HTTP button triggers the flow : giving you full functionality without requiring Power BI licenses for external users.

Thanks 
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster