how to views per day reports or dashboards power bi automatically

[josivanl]

I need a list of all reports or dashboards in Power BI Server for 10 or more days without use. The only resource I found is Usage Metrics, but this process is manual and I have a lot of reports to check.

Is it possible to make this list automatic?

[Anonymous]

Hi @josivanl ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[josivanl]

Unfortunately I didn't get the result I expected, I followed this link:  https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing#use-the-activity-log 

I ran this script and received the data in a .csv file: 

$UserCredential = Get-Credential

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection

Import-PSSession $Session
Search-UnifiedAuditLog -StartDate 9/11/2019 -EndDate 9/15/2019 -RecordType PowerBI -ResultSize 5000 |
Export-Csv -Path "c:\temp\PowerBIAuditLog.csv" -NoTypeInformation

Remove-PSSession $Session

Follow this link: https://radacad.com/build-your-own-power-bi-audit-log-usage-metrics-across-the-entire-tenant 

to be able to better understand and work with the file exported from PowerShell, but I can't know which column represents the total value of views, especially when a report has no views.

[Anonymous]

Hi @josivanl ,

Since you have a lot of reports/dashboards, creating a Power BI app is a good idea. Please refer to:

Apps in Power BI.

Publish an app in Power BI

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @josivanl 

As far as I know that is they only way to extract the data.

And as an FYI PowerShell is installed on every Windows PC

[GilbertQ]

Hi @josivanl 

What you could do is to use the Power BI Audit logs which gets all people who have accessed reports across the entire tenant. This will allow you to identify reports which have NOT been used or ones that are popular.

I have a blog post on how to do this with PowerShell and to be able to store them in Azure Blob storage

How you can store All your Power BI Audit Logs easily and indefinitely in Azure - Reporting/Analytic...

[josivanl]

Hi @GilbertQ 

Unfortunately we don't have PowerShell, only Power BI Server and I would like know if it is only possible with Power BI Server to get this informations?

Thanks!