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

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

Anonymous — Fri, 23 Jul 2021 17:04:03 GMT

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?

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

Anonymous — Mon, 26 Jul 2021 06:49:25 GMT

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

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

chrisarys — Tue, 27 Jul 2021 13:54:03 GMT

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 ?

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

DavidCousinsT — Tue, 27 Jul 2021 21:25:54 GMT

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.

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

Anonymous — Tue, 01 Oct 2024 15:47:47 GMT

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