cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JWhite-Somerset
Advocate I
Advocate I

[Resolved] Power Automate Visual 'Unsuccessful' for other users in Report

Edit - Resolved, first comment!
Hi, I'm using the 'Power Automate for Power BI' visual and it's working great for me (from desktop and from published report in the web. However in my published report, when other users click the button, it says 'Unsuccessful'. I'm not sure what could be causing this - the users have the correct (owner) permissions for the data source, and the button is still working fine for me, so it isn't a problem with the automation/flow... Any ideas what could be causing this or what else I could try please? Thanks

1 ACCEPTED SOLUTION
JWhite-Somerset
Advocate I
Advocate I

Hi everyone, figured it out. For anyone else trying to allow users to run flows:

  • Go into your Power Automate Flow (Details page, not edit)
  • In the bottom-right corner, there's a section called 'Run-only users'
  • Edit this section and add all of the anticipated report users that'll need this (can add groups as well - currently testing if adding a Teams group by the title of the team works as expected for all users) and this should then work!

View solution in original post

3 REPLIES 3
Bilal01
New Member

After Implementing RLS, users other than me are not able to see the Power Automate Button any idea why?

meorir
Frequent Visitor

Thank you!

JWhite-Somerset
Advocate I
Advocate I

Hi everyone, figured it out. For anyone else trying to allow users to run flows:

  • Go into your Power Automate Flow (Details page, not edit)
  • In the bottom-right corner, there's a section called 'Run-only users'
  • Edit this section and add all of the anticipated report users that'll need this (can add groups as well - currently testing if adding a Teams group by the title of the team works as expected for all users) and this should then work!

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.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Kudoed Authors