usage
7 TopicsHow does PBI Report Server calculate usage
SO I HAVE THIS CODE SNIPPET TO GET USAGE METRICS FOR USERS THAT VIEW DASHBOARDS MORE THAN 1 MINUTES, I DON'T TRUST THE QUERY RESULTS. But my main question is, why does the execution log table shows that users view reports in 1, 3 seconds? Is that time not too short to even load a report, talkless filtering visualizations.Is there a better way to write this query or get usage metrics? (the code snippet has been anonymized) SELECT c.[name] AS dashboardName, SUBSTRING(e.username, CHARINDEX('\', e.username) + 1, LEN(e.username)) AS reportUser, SUM(COUNT(*)) OVER (PARTITION BY c.[name], SUBSTRING(e.username, CHARINDEX('\', e.username) + 1, LEN(e.username))) AS Views, CAST(SUM(DATEDIFF(SECOND, e.TimeStart, e.TimeEnd)) AS NUMERIC(18, 0)) AS TotalSeconds, CAST(AVG(DATEDIFF(SECOND, e.TimeStart, e.TimeEnd)) AS NUMERIC(18, 0)) AS AverageSeconds, SUBSTRING(u.username, CHARINDEX('\', u.username) + 1, LEN(u.username)) AS dashboardBuilder FROM [Server].[dbo].[Catalog] c INNER JOIN [Server].[dbo].[executionlogstorage] e ON c.itemid = e.reportid INNER JOIN [Server].[dbo].[users] u ON c.modifiedbyid = u.userid WHERE e.TimeStart between 'XXXX-XX-XX' and 'XXXX-XX-XX' AND e.UserName NOT IN ('PowerBIReportServer','T SERVICE\PowerBIReportServer') AND DATEDIFF(ss, e.TimeStart, e.TimeEnd) >= 60 AND SUBSTRING(e.username, CHARINDEX('\', e.username) + 1, LEN(e.username)) != 'PowerBIReportServer' GROUP BY c.[name], SUBSTRING(e.username, CHARINDEX('\', e.username) + 1, LEN(e.username)), SUBSTRING(u.username, CHARINDEX('\', u.username) + 1, LEN(u.username))Solved1.1KViews0likes3CommentsCan i get the usage of individual page of a report in power BI report server
My questions are in order of priority: 1. Is there a way i can get the usage of indivual pages of the dashboards in my power bi report server? 2. Also asides querying the execution log and catalog from the db is there any GUI way of getting the report usage?454Views0likes1CommentWho logs in to PowerBI & to which reports - over a custom timeperiod?
Hello, I am wondering if I can track how frequent users login to/use PowerBI & which reports they have watched over a custom timeperiod (e.g. 1 year)? I understood currently that we can only view the reporting now over the past 3/4 weeks and that we need to do this analysis on report level (and cannot do it in bulk) Is this correcT? The goal is to understand which users really make use of PowerBI and of which reports and which users never login. Many thanks for your help & time upfront. KR, Charlotte1.2KViews0likes2CommentsA tooltip-like window to show where the selected measure/column was used across all pages?
Hello, I have a complex report (with several pages) and I want to remove the columns or measures that are not active member of my reports anymore. But since I could not see which measure is used in which visualization entirely (think that I have 10 - 15 pages in a report), I would like to have an option to see those, even if that measure has been used in other page but not in the page I am currently working on. Also this might be helpful for someone who takes over a job from someone else and wants to reduce the complexity of a report to increase the performance. Thank you very much for your time and consideration. Cheers!3.3KViews1like0CommentsPower BI On Prem Usage Tracking
Good Day Everyone, hope your day is going well. My Question is as follows. Our team would like to enable usgae tracking on our Power BI server to start gathering stats on usage per report etc. We have a On-Prem server, how do one go about enabling/Configuring usage tracking for Power BI? Regards RaynoSolved1.4KViews0likes2CommentsMonitor Power BI report pages usage stats on the Power BI report server
Hello, I would like to monitor the usage stats of my power bi reports on the on-premise power bi report server. I would like the breakdown by pages. In the ExecutionLog3, we have no information on the pages viewed on the report. Is there another way to retrieve this information?1.5KViews0likes2Comments