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