Forum Discussion

HulstB's avatar
HulstB
Frequent Visitor
6 years ago
Solved

PowerBI http request log audit

Where can I see the requests made to our PowerBI reports and their HTTP status codes?
Need Help
  • Icey's avatar
    Icey
    6 years ago

    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.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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