Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

extract page and dashlet name with Get-PowerBIActivityEvent from ExportReport

Hi, we are using the below PowerShell query to extract who exported the report from the Power BI reports. . It gives more of workspace name, report name, who exported, and a few other properties. Our need is to understand which page/tab and dashlet/grid they exported but from the output details, we can not find them. Any suggestions?

 

 

 

[System.Net.ServicePointManager]::SecurityProtocol = [System.Net.SecurityProtocolType]::Tls12

$activities = Get-PowerBIActivityEvent -StartDateTime '2022-07-01T00:00:00' -EndDateTime '2022-07-01T23:59:59' -ActivityType 'ExportReport' | ConvertFrom-Json

$activities[0]

 

 

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Base on my research, it does not return the properties about the report page information after executing the command Get-PowerBIActivityEvent xxx.

    You can call the REST API Reports - Get Pages to get the page infomation of the corresponding report by the special report name.

    GET https://api.powerbi.com/v1.0/myorg/reports/5b218778-e7a5-4d73-8187-f10824047715

    Best Regards

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Base on my research, it does not return the properties about the report page information after executing the command Get-PowerBIActivityEvent xxx.

    You can call the REST API Reports - Get Pages to get the page infomation of the corresponding report by the special report name.

    GET https://api.powerbi.com/v1.0/myorg/reports/5b218778-e7a5-4d73-8187-f10824047715

    Best Regards