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!