Monitor Average Execution Time etc for live Power BI reports

Hi,

first, use ExecutionLog3 view instead physical table, there are human readable labes instead codes.

But the problem is still here. You must little change how look on usage of PBI reports. It is because PBI reports (no mater if are in import mode or live connection mode) are interactive, for these reports there nothing like report open or report render time (like paginated reports). During interactive work with PBI reports users making many DAX queries, depened number visualisation on page, and not only during open report, but also during any click in report (on pages, on filters, on refresh button, when highlight any value, when drilling, when use slicers, and so on).

There are some steps during opening report:

-Report must be in to memory (SSAS) - if not, must be loaded (only for import mode reports)

-Must be loaded report definition for first time of use of user

-and for each visual on report must be executed DAX queries

For some performance and utilization statistics you can measure more values, like:

-How long takes loading model in to memory and how often (RequestType=Interactive, ItemAction=ASModelStream)

-Number of open definition by user (ItemAction=ConceptualSchema)

-And most important, number and execution time of queries (ItemAction=QueryData). I mean execution time of QueryData is most important, and for example I'm monitoring Average, 50th, 75th and 95th Percentile of execution time (in miliseconds).