Forum Discussion

mehuljain's avatar
mehuljain
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago

Service account - PowerBINotAuthorizedException

Hi, We have created a power Automated flow. In those flows are using power BI connectors to get the data from power BI reports. We have written a dax query and created a connection using workspace I...
Need Help
v-echaithra's avatar
v-echaithra
Icon for Community Support rankCommunity Support
1 year ago

Hi mehuljain ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.

mehuljain's avatar
mehuljain
Icon for Microsoft Employee rankMicrosoft Employee
1 year ago

Hi, Thanks for your suggestion. 

 

As of now, it is not working with service accout. 

We haven't tried it for service percipal as our environment will not allow http calls. 

 

Thanks

  • v-echaithra's avatar
    v-echaithra
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi mehuljain ,

    Thanks for the update.

    Make sure the service account has an active Power BI Pro license.

    Add Service Account to the Workspace, ensure the service account is a member or contributor.

    Ensure the service account has "Build" permission on the dataset.

    Sign in to Power BI Connector in Power Automate. In Power Automate: Open Data > Connections.

    Find the Power BI connector and edit/re-authenticate it using the service account's credentials.

    Manually test access in Power BI service by Loging into https://app.powerbi.com using the service account. Try opening the dataset or report manually. If access is denied here too, it's not a Power automate issue, it’s a permission problem in Power BI.

    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,
    Chaithra.




    • mehuljain's avatar
      mehuljain
      Icon for Microsoft Employee rankMicrosoft Employee
      1 year ago

      Thanks for your response. I tried logging in using my service account manually into msit.powerbi.com but i am getting below error 
      Your sign-in was successful but does not meet the criteria to access this resource. For example, you might be signing in from a browser, app, or location that is restricted by your admin.

      • v-echaithra's avatar
        v-echaithra
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi mehuljain ,

        This issue arises when admin access has not been assigned to your application in the Power BI workspace, leading to the PowerBINotAuthorizedException error.

        Follow the below steps to fix the issue:

        Navigate back to the Home page. Click on the Workspaces tab from the left pane and then select your workspace from the list.
        Choose the Manage Access option in the navbar.
        When you click on Manage Access, you will be presented with a screen showing the current users and security groups having access to the workspace.
        You can then click on Add people or groups so as to provide access.
        After that, you will need to select Admin from the dropdown and add the user according to your requirements.
        Now access for the workspace configuration is completed, select the report that you want to embed in a WordPress page or post.

        Please refer to link below to learn more about how to troubleshoting a flow and see if your problem could be solved: Troubleshoot a cloud flow - Power Automate | Microsoft Learn

        This error "Your sign-in was successful but does not meet the criteria to access this resource" is usually due to some Conditional Access policy. In some cases, there may be certain account or system restrictions such as preinstalled certificates, token usb key, geographical location, etc... that will be needed to log in. The suggestion is to check with the administrator, for reference you can read the next article: Troubleshooting sign-in problems with Conditional Access - Microsoft Entra ID | Microsoft Learn

        I hope this helps you.
        Best Regards,
        Chaithra E.