Forum Discussion

pontushaglund's avatar
pontushaglund
Helper I
5 years ago

401 error trying to fetch Power BI Activity Log

I'm trying to use the Power BI REST API to fetch Power BI Usage Reports using a service principal. When using PowerShell I can fetch the reports using a user/password that has MFA turned on. My customer wants to use a service principal rather than a AD user that has MFA turned off.

I first call to get a token:

 

Using that token I call:

When calling this I get a 401 Unauthorized. 
 
The user must have administrator rights (such as Office 365 Global Administrator or Power BI Service Administrator) to call this API.
 
Is it therefore not possible to get the activity logs using a service principal?
Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    I assume your organization's IT team do not want to give these admin rights to a service principal login?

    • pontushaglund's avatar
      pontushaglund
      Helper I
      5 years ago

      Is it even possible? I've added the service principal in the Power BI Admin portal. Still 401. Am I missing something?

    • pontushaglund's avatar
      pontushaglund
      Helper I
      5 years ago

      I now tried adding the service principal to the role Power BI Admin in the Azure portal. This did not help, still getting 401 error.

       

      This user is also part of a security group:

      I've also allowed access for this security group in the Power BI portal:

       

  • VSmart's avatar
    VSmart
    Frequent Visitor
    3 years ago

    Is This any solution I also try to get audit logs. Add my app to security group, give rights to this group but still get a 401 Unauthorized.