Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Refresh Power BI Dataset using Power Automate (flow) with Viewer permissions in app workspace

Hi all, Hope you are doing good! I have a scenario which is a head scratcher for me. need your inputs 🙂 I am refreshing a Power BI dataset via a flow. UI is Power Apps platform which takes dates ...
  • ibarrau's avatar
    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

  • Anonymous's avatar
    Anonymous
    3 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!!