Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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?

  • Anonymous's avatar
    Anonymous
    5 years ago

    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 ?

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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 ?

    • Anonymous's avatar
      Anonymous
      Not applicable

      I'm facing the same issue, can you give me more information on how to do this please?

  • Anonymous's avatar
    Anonymous
    Not applicable

    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