cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Number of visitors on the dashboard - on power bi report server.

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

7 REPLIES 7
Highlighted
Post Patron
Post Patron

Re: Number of visitors on the dashboard - on power bi report server.

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 ~!!! 

 

1.PNG

 

2.PNG

 

Highlighted
Post Patron
Post Patron

Re: Number of visitors on the dashboard - on power bi report server.

Dear @prajakta ,

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 

Highlighted
Frequent Visitor

Re: Number of visitors on the dashboard - on power bi report server.

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

Highlighted
Post Patron
Post Patron

Re: Number of visitors on the dashboard - on power bi report server.

Dear @prajakta  ,

@ 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

Highlighted
Post Patron
Post Patron

Re: Number of visitors on the dashboard - on power bi report server.

Hey , 

 

Try connecting  to the dbo.ExecutionLog3 view from  SQL database 

 

It will do the needful I think 

Highlighted
Resolver II
Resolver II

Re: Number of visitors on the dashboard - on power bi report server.

 

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.

Highlighted
Memorable Member
Memorable Member

Re: Number of visitors on the dashboard - on power bi report server.

Hi @prajakta ,

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!

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Kudoed Authors