PowerBI http request log audit

[HulstB]

Where can I see the requests made to our PowerBI reports and their HTTP status codes?

[Icey · Accepted solution]

Hi @HulstB ,

As a Power BI service admin, you can analyze usage for all Power BI resources at the tenant level by using custom reports based on the Power BI activity log. You can download the activities by using a REST API or PowerShell cmdlet.

For details, please refer to this document: Track user activities in Power BI.

I tested the PowerShell method:

1. If you don't installed the Power BI Management cmdlets locally, please install it first.

Install-Module -Name MicrosoftPowerBIMgmt

Or, update it:

Update-Module -Name MicrosoftPowerBIMgmt

2. Get Power BI activity log.

Login-PowerBI
$activities = Get-PowerBIActivityEvent -StartDateTime '2020-01-01T00:00:00.000'-EndDateTime '2020-01-01T23:59:59.999' | ConvertFrom-Json
$activities.Count
$activities[0]

Best Regards,

Icey

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

[Anonymous]

Hi 

Thank you. 

I am trying to use the rest api but getting error "403Forbidden". 

I am using the basic authentication with username/password. The user has "Power BI admin" role.

Do you know why this error is coming?

Thanks 

Naresh

[HulstB]

This is very usefull, especially with the example output. I will try it out. Thanks.