Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I need to find how many users have visited and used the report which is on the power bi report server. Is there a way to get the number of visits to a dashboard on report server?
Regards,
Prajakta
On Report Server Database execute :
SELECT
ReportPath,
UserName,
CAST(TimeStart AS Date) AS DayOfView
--TimeStart --if you want exact time uncomment this line
FROM [dbo].[ExecutionLog2]
WHERE [Format]='RPL'
This only retrieves report views, but not exports. If you want to see exports, try changing 'RPL' to 'EXCELOPENXML' for excel, for example, or what ever you want.
Hi @Anonymous ,
in the exceutionlog3 or executionlogstorage - Column: Report Action :
WHEN 1 THEN 'Render'
WHEN 2 THEN 'BookmarkNavigation'
WHEN 3 THEN 'DocumentMapNavigation'
WHEN 4 THEN 'DrillThrough'
WHEN 5 THEN 'FindString'
WHEN 6 THEN 'GetDocumentMap'
WHEN 7 THEN 'Toggle'
WHEN 8 THEN 'Sort'
WHEN 9 THEN 'Execute'
WHEN 10 THEN 'RenderEdit'
WHEN 11 THEN 'ExecuteDataShapeQuery'
WHEN 12 THEN 'RenderMobileReport'
WHEN 13 THEN 'ConceptualSchema'
WHEN 14 THEN 'QueryData'
WHEN 15 THEN 'ASModelStream'
WHEN 16 THEN 'RenderExcelWorkbook'
WHEN 17 THEN 'GetExcelWorkbookInfo'
WHEN 18 THEN 'SaveToCatalog'
WHEN 19 THEN 'DataRefresh'
😉
Best,
Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!
Hey ,
Try connecting to the dbo.ExecutionLog3 view from SQL database
It will do the needful I think
Dear Prajakta , Yes there is a way of analyzing who viewed your report and from which platform i.e mobile / web .
See images for underrstanding , first open that report in app,powerbi.com
then select three dots from tool bar above report and select usage metrics .
and them tada ~!!!
Hi Sujit,
It seems this solution is applicable in power bi service and not on Power BI report server. Is it possible to do the same in Power BI report server?
Regards,
Prajakta
Dear @Anonymous ,
@ The Power BI Report Server sits on a SQL instance (the same as normal SSRS) you have access to all the capabilities and information stored in the database. the view "dbo.ExecutionLog3" will provide you the metrics that you are looking for .
Regards
Sujit Thakur
Please give kudos and accept anser if I landed you to your solution
Dear @Anonymous ,
Please give kudos by clicking a thumbs up and accept my reply as solution if my reply brought you to your desired solution.
happy to help
regards ,
sujit thakur
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |
User | Count |
---|---|
19 | |
15 | |
3 | |
2 | |
2 |