power bi report server performance
1 Topic
Monitor Average Execution Time etc for live Power BI reports
Hi, Is there a smart way to get some kind of average execution time for a (live SSAS) report in Power BI Report Server. I know about the dbo.ExecutionLogStorage table in the ReportServer-database, but my problem is that it seems that I get multiple rows in this table per render and I can not find a way to relate which rows that belongs to the same "report refresh" so to say. It would also be interesting to see how many times a report has been "refreshed" (for example filter changed) per day, but that is kind of the same problem. I see that the first time you open a report you get a line with ReportAction=13, but if you then just change a filter in the report so that the report is refreshed you get multiple lines with ReportAction=14. Maybe I can sum up the execution time (TimeEnd-TimeStart) to get some kind of total, but how to get a good average or execution count? How do you monitor the performance of your reports?Solved1.6KViews0likes1Comment