Reputation: 11
We want to create Power BI dashboard highlighting statistics of user activities related to Power BI for last 30/90 days.
Below are the high level statistics we want to capture:
Would want to know if there is any available solution or OOB Power BI connector for the same.
Thanks
Upvotes: 0
Views: 497
Reputation: 122
You have 2 options:
The easy one:
go to a report, get the "usage metrics" then delete the filter applied to this report. You now have a "global usage metrics" for every report in the tenant. pro: easy, cons: you don't have everything.
The hard one:
@Trisa Biswas answer is correct, you can use the rest api to get everything you need. Pro: it's complete. cons: it's more complicated.
PS: to get the usage metrics:
Open a report online, "...", get usage metrics, save a copy in your workspace, delete the filter "ReportGuid".
Upvotes: 0
Reputation: 16
To check 30 days statistics Power BI has "Usage metrics" features for every report. Other than this you can use your O365 data if you are an admin of Power BI services
Upvotes: 0
Reputation: 593
You can analyze statistics of user activities using the Power BI Activity log. You can download the activities by using a REST API or PowerShell cmdlet. You can also filter the activity data by date range, user, and activity type. In order to be able to do this, you should be a Power BI Service Admin. You have to install the Power BI Management cmdlets locally or use the Power BI Management cmdlets in Azure Cloud Shell.
You will find more details here : https://powerbi.microsoft.com/en-us/blog/the-power-bi-activity-log-makes-it-easy-to-download-activity-data-for-custom-usage-reporting/
Upvotes: 1