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

How to Get Usage Statistics from On-Premise Power BI Report Server?

Hi all,

 

We are using on premise Power BI Report Server to host reports developed with our Power BI Desktop. What we want to track now is the number of users that visit these reports. We will like to know which user visited a report and how often. We will like to know the number of daily, monthly and yearly visits. How can we obtain this from the Power BI Report Server?

2 REPLIES 2
____TJ Frequent Visitor
Frequent Visitor

Re: How to Get Usage Statistics from On-Premise Power BI Report Server?

Hi divo,

 

You can use the same queries on the ReportServer database for Power BI, as the ones you can use for a traditional SSRS (Reporting Services) database. If you search for 'SSRS Usage Statistics', you get tons of sample queries. You must tweak them a bit though, and filter some records; some (render/report) types are different. 

jopasqui Frequent Visitor
Frequent Visitor

Re: How to Get Usage Statistics from On-Premise Power BI Report Server?

Hello @divo 

 

You will find 2 ways to report usage statistics on Power BI Report Server :

 

* using the old way (like in SSRS), you can query the Report Server DB and retrieve all kind of information, the most famous view to query is ExecutionLog3, which will help you retrieving data on all kind of action on the report server (refresh on a specific DataSourceDataModel, report execution for a specific report ID by a specific user ID). Using other tables as dimensions, you can build a nice data model on Power BI.  Some documentation on executionLog: https://docs.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and...

* the other way, using the API of PBIRS (oData), and GET functions, you can get refined information (some type IDs are traduced in human language for example). The API uses the DB tables and views, but add information. Some information is tricky to get and will require few skills in M, for example if you want to get History of refresh execution, you will need to build an M function to rebuild URLs. Api swagger : https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0

 

 

Please note that data retention is 60 days by default, but can be modified. More information here : https://blogs.msdn.microsoft.com/shiyangqiu/2016/09/12/reporting-service-execution-log-retention/

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 170 members 1,764 guests
Please welcome our newest community members: