Issue:
I created a Power Automate button inside my Power BI report that triggers a Power Automate flow. The flow is premium and uses an HTTP connector to call an Azure Data Factory (ADF) pipeline when pressed.
The Power Automate flow has two steps:
- PowerBiButtonClicked operation
- HTTP operation (POST method) to trigger the ADF pipeline
I can successfully trigger the flow from my non-premium Power Automate account. However, another user (who has been given permissions) gets an "unsuccessful" message when pressing the button.
What I’ve Tried:
- Granted the user Admin permissions in the flow.
- Moved the user to Run-Only Users while keeping Admin permissions.
- Gave them only Run-Only permissions (Both Run Only assignments were configured to use the premium Power Automate account).
- Verified that we both have the same Power BI license and equal privileges in Azure.
The only difference is that I have a managed Power BI connection, while the other user does not. I'm unsure if this is necessary for the button to work. Additionally, I noticed that the other user has no entry under the "28-day run history" table, meaning there is no historical record of them even attempting to trigger the flow.
Question
Could the missing managed Power BI connection be causing the issue? If not, what else could be preventing the other user from triggering the flow? Any insights or suggestions would be greatly appreciated!