Forum Discussion

urraghu's avatar
urraghu
Frequent Visitor
5 years ago

retrieve specific workspaces data using Get-PowerBIActivityEvent

We are able to retrieve activity logs using "Get-PowerBIActivityEvent" but it is returning the activity logs for all workspaces in the tenant. I see only side parameters like -UserId and -ActivityType are available for ‘Get-PowerBIActivityEvent’ for filtering data. My requirement is to retrieve/filter data based on parameters like Workspaces names or Workspace Owner names. please help to advise on the possibilities. 

data protection
Need Help

4 Replies

  • arvindsingh802's avatar
    arvindsingh802
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Currenlty that does not allow you to filter data based on Worksapce owner as this is user activities logs.

     

    I would suggest to pull the data and filter it based on your requirement in next step. (i.e. workspaceid)

     

    If this post helps, then please consider Accept it as the solution and give it a thumbs up

  • urraghu's avatar
    urraghu
    Frequent Visitor
    5 years ago

    We have a requirement to pull these logs on a weekly basis (and filter data based on Workspace name/owner). Any inputs on automating such requirement?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      It can be done using something like this
      $allAudits = Get-PowerBIActivityEvent -StartDateTime $pivotDate.ToString("s") -EndDateTime $pivotDate.AddHours(24).AddSeconds(-1).ToString("s") -ActivityType "ViewReport" | ConvertFrom-Json


      $audits = $allAudits | Where-Object { $_.WorkspaceName -eq "your_workspace_name" }