Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pontushaglund
Helper I
Helper I

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:

pontushaglund_0-1603083392028.png

 

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?
4 REPLIES 4
VSmart
Frequent Visitor

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.

lbendlin
Super User
Super User

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

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.

pontushaglund_0-1603168382889.png

 

This user is also part of a security group:

pontushaglund_1-1603168704251.png

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

pontushaglund_2-1603168748371.png

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors