Power BI Report Server - Get number of User Sessions/ Report Views/ Frequency of Usage for a Report
Hi, As I can see, there is no specific field that tracks User Sessions on Power BI Report Server. There is no log out option for the user on the web-portal either. Similarly, I found the logs very confusing and I m not sure if the approach taken to count total number of Report Views is Correct. I m inferring count of distinct execution ids where ItemAction != "SaveToCatalog" and != "DataRefresh" from ExecutionLog3 as total number of Report Views. Is this correct? I intend to track the frequency of access to a report by users and track the total number of views by each user. Is there a way I can get the total number of user sessions and frequency of usage. Thanks & regards, Mannu
How To Find SQL Queries from Report on Report Server
Hi, I have published report to Power BI Report Server (on-premise) and would like to analyse SQL queries fired by the report to fine tune my model. There are multipe views and the model is complex with lots of joins. The views by themselves are huge and the report takes lot of time to load after each slicer selection. I have gone through similar posts but my requirement is slightly different: 1. I prefer to collect logs of all queries fired by the report (similar to gateway logs of Power BI Service) 2. My requirement is not just about analysing query folding on a specific view (which I can do from within PBI desktop) How do I accomplish this on Report Server (as we do not use a gateway here) Thanks, Mannu