Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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.
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.
This user is also part of a security group:
I've also allowed access for this security group in the Power BI portal:
Is it even possible? I've added the service principal in the Power BI Admin portal. Still 401. Am I missing something?
User | Count |
---|---|
14 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
16 | |
11 | |
5 | |
4 | |
3 |