Enabling End Users to Refresh Dataset

[CWitts]

I have tried to enable end users to be able to refresh a dataset within a Power BI App, but it is always unsuccessful.  I have use the option of Power Automate for Power BI as the visualisation and the user has "Member" access to the App and a Pro License to Power BI.  The dataset is being pulled through from our main database using an SQL report and a Gateway.  Access to the Gateway is strictly maintained and it isn't possible to allow end users to have access to this (which may be the issue).

Has anyone got any ideas on how this can be done and/or what the end user will need to have acess to?

[danextian]

Hi @CWitts 

I have a member role in a workspace and I am able to refresh a dataset without taking it over.  Do your users have a member access to the Power BI workspace as well or maybe just viewers? The user or account used to refresh needs the correct permission. The suggesion is to use service principa account - https://community.fabric.microsoft.com/t5/Service/Refresh-Power-BI-Dataset-using-Power-Automate-flow...

[lkalawski]

@CWitts , please check this documentation:
https://learn.microsoft.com/en-us/training/modules/share-cloud-flow/share-run-only

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin

[CWitts]

Fantastic - do they need anything higher than Viewer access rights to the App?

[lkalawski · Accepted solution]

@CWitts, Viewer level should be sufficient.

[lkalawski]

Hi @CWitts ,

Did you share the flow with the end user?

You definitely don't need to add gateway access.

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin

[CWitts]

How do you share the flow?