cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Luukvnv93
Helper I
Helper I

Error accessing Power BI REST API: Admin - Get Activity Events using Service Principal auth

Hello,

 

I try to access the Get Activity Events using Service Principal auth with Python.

I did succesfully manage to obtain the token, however using below's code I get the following error upon retrieving activity events from the API..

 

{'error': {'code': 'PowerBINotAuthorizedException', 'pbi.error': {'code': 'PowerBINotAuthorizedException', 'parameters': {}, 'details': [], 'exceptionCulprit': 1}}}

 

import adal
import requests
import json
import datetime

tenant_id = ""
authority_url = 'https://login.microsoftonline.com/'+tenant_id+'/'
resource_url = 'https://analysis.windows.net/powerbi/api'
client_secret = ""
client_id = ""
context = adal.AuthenticationContext(authority=authority_url,
                                     validate_authority=True,
                                     api_version=None)
token = context.acquire_token_with_client_credentials(resource_url, client_id, client_secret)
access_token = token.get('accessToken')

print(requests.get(f"https://api.powerbi.com/v1.0/myorg/admin/activityevents?startDateTime='2021-07-22T00:00:00Z'&endDateTime='2021-07-22T23:59:59Z'", headers = {'Authorization': f'Bearer {access_token}'}).json())

 

- I enabled Service Principal Read Only API in the admin portal in Power BI.

- I added the App Registration to the security group that is assigned in the setting

 

What am I doing wrong?

1 ACCEPTED SOLUTION
chrisarys
New Member

we had the same issue and after investigations with MS support we found out that the Admin Consent should be removed from the app permissions.  Once removed the 

PowerBINotAuthorizedException

error was gone !

 

Hope it helps ?

View solution in original post

3 REPLIES 3
DavidCousinsT
Frequent Visitor

If chrisarys response doesnt help, try changing resource_url to https://analysis.windows.net/powerbi/api/.default

 

I had to include the .default bit at the end of the URL to ensure the token generated gave access to all of the Power BI api.

chrisarys
New Member

we had the same issue and after investigations with MS support we found out that the Admin Consent should be removed from the app permissions.  Once removed the 

PowerBINotAuthorizedException

error was gone !

 

Hope it helps ?

View solution in original post

v-shex-msft
Community Support
Community Support

Hi @Luukvnv93,

Have you worked with the account that has enough permission to operation and traces these activity logs? Did these contents managed in premiums capacity? 

Please share more detailed information to help us clarify this scenario:

How to Get Your Question Answered Quickly  

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.