Josef Jurák on 07 Feb 2021 14:02:41
Please Expose Perfmon counters for Power BI Report Server.
Currently, in Power BI Report Server are very limited options how to monitor performance and usage. Really, there are zero options how to monitor performance (except to CPU and Memory counters on OS level), and minimum options how to monitor usage (only ExcecutionLog3 view on DB server). Additionally, some options to monitor performance are possible thru DMV on SSAS instance, but they are very limited, and unsupported.
Power BI Report Server is primary based on integrated SQL Service Analysis Services (SSAS), which in standalone installation providing many Perfmon counters to monitor performance in Windows Performance Monitor. In SSAS integrated in Power BI Report Server are Perfmon counters disabled. Same situation is for Report Server Perfmon counters.
Please, expose current Perfmon counters from SSAS and RS instances integrated in Power BI Report Server to Windows Performance Monitor.
Thanks
- Comments (2)
RE: Power BI Report Server: Performance Monitoring
I would like to see this detail of Power BI report to help identify poorly written Power BI reports. Using the ExcecutionLog3, I can eastly see poorly written reports based on the status BUT for Power BI there is no such option. to see if a 1 GB of data is being transferred from SQL Server to PB Report.
RE: Power BI Report Server: Performance Monitoring
It is very much needed to get performance statistics, who is running reprots and more. The "RSExecutionLog" provided by Microsoft for SSRS years ago was a great archiving solution for SSRS analytics. At minimal, some guidance in upgrading this legacy process to work for Power BI reports would be appreciated, if not a simple view in the database.