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 ConvertFrom-Json
    $activities = Get-PowerBIActivityEvent `
        -StartDateTime $start `
        -EndDateTime $end `
        -ActivityType 'ViewReport' `
        -ErrorAction Stop | ConvertFrom-Json

    $activities[0]

That outputs the following:

Id                       : {}
RecordType               : {}
CreationTime             : {}
Operation                : {}
OrganizationId           : {}
UserType                 : {}
UserKey                  : {}
Workload                 : {}
UserId                   : {}
ClientIP                 : {}
UserAgent                : {}
Activity                 : {}
ItemName                 : {}
WorkSpaceName            : {}
DatasetName              : {}
ReportName               : {}
CapacityId               : {}
CapacityName             : {}
WorkspaceId              : {}
ObjectId                 : {}
DatasetId                : {}
ReportId                 : {}
ArtifactId               : {}
ArtifactName             : {}
IsSuccess                : {}
ReportType               : {}
RequestId                : {}
ActivityId               : {}
DistributionMethod       : {}
ConsumptionMethod        : {}
ArtifactKind             : {}
RefreshEnforcementPolicy : {}
BillingType              : {}

I am trying to figure out why I am getting objects for which each attribute is just an empty list. I have followed the official documentation for this Cmdlet but I can't figure out why this is happening. 
I've also tried not using ConvertFrom-Json and just log the Json string. However, I get the same result. 

Documentation I'm following: Access the Power BI activity log - Power BI | Microsoft Learn

  • 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.

10 Replies

  • Deku's avatar
    Deku
    Super User

    You might need to add milliseconds to datetimes string to make it valid

    • Anonymous's avatar
      Anonymous
      Not applicable

      Good idea, I changed the dates as such:

      $start = (Get-Date).AddHours(-10).ToString("yyyy-MM-ddTHH:mm:ss.fff")
      $end = (Get-Date).ToString("yyyy-MM-ddTHH:mm:ss.fff")

       I still get the same output though

      • Deku's avatar
        Deku
        Super User

        Does it work without the activitytype filter? 

  • v-kathullac's avatar
    v-kathullac
    Community Support

    Hi Anonymous  ,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.


    Regards,

    Chaithanya.