Forum Discussion
Refresh Power BI Dataset using Power Automate (flow) with Viewer permissions in app workspace
- 4 years ago
You should be able to solve this conundrum by using a service principal:
https://benediktbergmann.eu/2022/01/04/setup-a-service-principal-in-power-automate/
- 4 years ago
Hi. Like otravers says you might want to use a service account (like service pricipal). The main thing here is that the user or account used to refresh needs more permissions, so it can't be inside of a security group that can only "View" inside the workspace. The service principal is usually the best option because it doesn't depends on a user, it's an app registered for the organization.
I hope that make sense - Anonymous3 years ago
Thanks for your relpies otravers ibarrau
Well this is the ideal solution which should be implemented from the start. Thanks for letting me know.
Also, the other solution which worked in my specific case is just run the flow with the account which has higher level of permissions (like ibarrau mentioned in his answer). The new task (PowerApps V2) inside flow allows to do this.
This way we can restrict user from Power BI workspace perspective but at the same time can allow them to just refresh the dataset.
Thanks for your help guys!!
Thanks for your relpies otravers ibarrau
Well this is the ideal solution which should be implemented from the start. Thanks for letting me know.
Also, the other solution which worked in my specific case is just run the flow with the account which has higher level of permissions (like ibarrau mentioned in his answer). The new task (PowerApps V2) inside flow allows to do this.
This way we can restrict user from Power BI workspace perspective but at the same time can allow them to just refresh the dataset.
Thanks for your help guys!!
How can you use PowerApps V2 trigger to run the flow with a different account?