Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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 ?
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.
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 ?
Hi @Anonymous,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
2 | |
2 | |
2 | |
2 |