Questions about Power BI Usage Metrics Report

Power BI
1

Hello Power BI experts!

I am working on developing a “Power BI usage metrics report” that will present information on what reports are being viewed over time, as well as usage metrics at the user level.

I am using Power BI’s “Report Usage Metrics Model” dataset for this report. I had a few questions and would be grateful if I can get some insights on this. My questions are as follows:

1.) Currently the data for this Power BI dataset goes back only 90 days. Is it possible to to get data further back than just 90 days, for example from a year ago?

2.) Is there a way to use Power Query or manipulate this date? One of the tables has columns “FamilyName” and “GivenName”, and I would love to have a new column that’s a concatenation of those two columns.

3.) Is there a way to get usage metrics information at the report page level?

4.) Is it possible to set a live connection to SQL Server so that we are able to archive or build historical data off this?

Thank you very much for your insights and assistance!

2

Please go and vote on this idea to retain data more than 90 days
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19469353-maintain-dashboard-report-usage-metrics-data-for

You can also refer this website on a very useful video from RADACAD where you can use powershell to export audit log data in the power bi report using a csv file to build custom report.

Hope this helps…

thank you .

3

Hi @GrapeApe561

Yes you can concatenate 2 columns either by adding a new column and using the function “concatenate” or you can make both the columns as text and add a custom column in query editor and there select [FamilyName] ’ ’ [GivenName] and you would get your result.

4

Hi @GrapeApe561

Please refer to the below link.

5

Hi @GrapeApe561, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!