topic Re: Unauthorized 401 API powerbi admin activity events in Developer

Unauthorized 401 API powerbi admin activity events

Anonymous — Wed, 18 Jun 2025 17:56:47 GMT

Hello,

I am trying to use admin activity events api to get views on reports in a workspace. I have created these following activities to provide proper api access:
-Registered the api

-Gave powerbi application permission api access for tenant.read.all
-Granted Admin consent

-created a secret

-Modified powerbi tenant setting to allow service principal to call the API

-Created a security group and added my enterprise application in that security group and added that in powerbi tenant settings to call the API

-Even added the enterprise application in Fabric adminstrator role and it still returns 401 unauthorized.

The report level api returns data, but admin activity event doesn't return anything other then 401.

Can someone please provide any guidance on what else could I be missing and I am testing the API call in postman to see if it gives me the 200

Re: Unauthorized 401 API powerbi admin activity events

v-venuppu — Thu, 19 Jun 2025 06:22:35 GMT

Hi @Anonymous ,

Thank you for reaching out to Microsoft Fabric Community.

It looks like you've set up most things correctly, but the 401 Unauthorized error usually comes down to one or two key missing steps.

Here’s a simple checklist to help you fix it:

1.Make sure your app has the AuditLog.Read.All permission (not just Tenant.Read.All).

2.When generating the token, you must request it for Microsoft Graph, not just Power BI(Use Graph API token scope)

3.Even if the service principal is added in Fabric Admin, the activity events API only works if it's a Power BI Admin (or Global Admin).

4.Audit data can take up to 24 hours to show up. So if you’re testing with very recent activity, it might return empty even if authorized correctly.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly.

Thank you.

Re: Unauthorized 401 API powerbi admin activity events

v-venuppu — Mon, 23 Jun 2025 07:27:31 GMT

Hi @Anonymous ,

I wanted to check if you had the opportunity to review the information provided.If the response has addressed your query, please accept it as a solution, so other members can easily find it.

Thank you.

Re: Unauthorized 401 API powerbi admin activity events

Anonymous — Mon, 23 Jun 2025 13:52:24 GMT

Hi @v-venuppu ,

Thank you for your response and giving me some tips! I tried the steps you mentioned but they didn't give me the 200OK for getactivityevents API. I tried going the delegated permissions route and gave it tenant.read.all and write.all and kept everything else same as I mentioned up there and it worked and now I am getting all of the events for a day! Thank you for providing a repsonse and give me some tips to try out. Would you know if there is a way to get more then one days worth of views metrics from that call or we can only get one day and there is some other work around we have to do?

Re: Unauthorized 401 API powerbi admin activity events

v-venuppu — Tue, 24 Jun 2025 11:20:13 GMT

Hi @Anonymous ,

No, the GetActivityEvents API only supports retrieving one day of data per request.You cannot get multiple days in a single call.

As a Workaround to get more than one day of metrics, you need to call the API repeatedly, once per day, using different startDateTime and endDateTime values for each date.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly.

Thank you.

Re: Unauthorized 401 API powerbi admin activity events

v-venuppu — Fri, 27 Jun 2025 05:48:15 GMT

Hi @Anonymous ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: Unauthorized 401 API powerbi admin activity events

Anonymous — Fri, 27 Jun 2025 18:21:36 GMT

Hey @VE I made a python script to loop over the api call to get all events for the past 30 days as you can make 200 api calls in an hour so I am following that process and ingesting my data into azure sql db! Thank you for your help!

Re: Unauthorized 401 API powerbi admin activity events

v-venuppu — Mon, 30 Jun 2025 11:02:28 GMT

Hi @Anonymous ,

Thank you for sharing the working solution.Please accept the helpful solution as answer so that it will he helpful for others in the community to find the solution easily.

Thank you.

Re: Unauthorized 401 API powerbi admin activity events

PravinPCUK — Thu, 18 Sep 2025 14:11:35 GMT

Hi @v-venuppu @Anonymous

I tried all the above steps,

Created an app in Azure Entra
Assigned Tenant.Read.All, write all roles
Created Secret
Created a security group for the Service Principal
Added Service Principal to Fabric Admin role
Added the newly created security group in the tenant settings in Power BI admin portal

but still getting 401 error. Any suggestions on how to fix it??

Note: I'm able to access workspace & reports but not able to access activity events

Re: Unauthorized 401 API powerbi admin activity events

v-venuppu — Fri, 19 Sep 2025 08:02:03 GMT

Hi @PravinPCUK ,

As this thread is already solved, please create a new thread in the forum.We are happy to help.

Thank you.