Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Get-PowerBIActivityEvents returns a list of objects with empty list attributes

I have the following code:  $start = (Get-Date).AddHours(-10).ToString("yyyy-MM-ddTHH:mm:ss") $end = (Get-Date).ToString("yyyy-MM-ddTHH:mm:ss") # Don't pipe through Out-String or ConvertFr...
Need Help
  • v-kathullac's avatar
    v-kathullac
    1 year ago

    Hi Anonymous ,

    Thank you for reaching out to Microsoft Fabric Community Forum.

     

    The error you're getting from Get-PowerBIActivityEvents means your current Power BI account doesn't have the required admin privileges to access activity log data.

    You must have :

    • Power BI Service Administrator OR

    • Office 365 Global Administrator

    If you're not one of these, you'll need to request access from your IT/Admin team.

     

    Regards,

    Chaithanya.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Updated the code as such:

$start = (Get-Date).AddDays(-30).ToString("yyyy-MM-ddTHH:mm:ss.fff")
$end = (Get-Date).ToString("yyyy-MM-ddTHH:mm:ss.fff")
Write-Host $start to $end
$activities = Get-PowerBIActivityEvent `
        -StartDateTime $start `
        -EndDateTime $end | ConvertFrom-Json `
        -ErrorAction Stop
$activities

I get the following output and error:

2025-03-16T08:15:00.598 to 2025-04-15T08:15:00.599
Get-PowerBIActivityEvent : Operation returned an invalid status code 'BadRequest'
At C:\Users\jafarip\OneDrive - TC TC\Desktop\DV-RD\Scripts\Get-MigrationActivityEvents.ps1:7 char:19
+     $activities = Get-PowerBIActivityEvent `
+                   ~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : WriteError: (Microsoft.Power...BIActivityEvent:GetPowerBIActivityEvent) [Get-PowerBIActivityEvent], HttpOperationExcep  
   tion
    + FullyQualifiedErrorId : Operation returned an invalid status code 'BadRequest',Microsoft.PowerBI.Commands.Admin.GetPowerBIActivityEvent

It's becasue the Cmdlet doesn't work with long time ranges (30 days). I tested that it works with max half a day worth of range.  

v-kathullac's avatar
v-kathullac
Community Support
1 year ago

Hi Anonymous ,

Thank you for reaching out to Microsoft Fabric Community Forum.

 

The error you're getting from Get-PowerBIActivityEvents means your current Power BI account doesn't have the required admin privileges to access activity log data.

You must have :

  • Power BI Service Administrator OR

  • Office 365 Global Administrator

If you're not one of these, you'll need to request access from your IT/Admin team.

 

Regards,

Chaithanya.