usage

5 Topics

How 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))
Solved
opejoseph
3 years ago Place Report Server
1.1KViews
0likes
3Comments
Can 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?
opejoseph
3 years ago Place Report Server
454Views
0likes
1Comment
Power 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 Rayno
Solved
Anonymous
7 years ago Place Report Server
1.4KViews
0likes
2Comments
Monitor 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?
Anonymous
7 years ago Place Report Server
1.5KViews
0likes
2Comments
Report Server - Report Usage Statistics
Hi - PowerBI Service allows you to view report usage via the Admin Portal and in the service. Is this possible in Report Server. We are moving to report server and it would be nice to see report usage metrics.
Solved
shera276
8 years ago Place Report Server
31KViews
1like
7Comments