Extended Events is a highly configurable and lightweight performance monitoring system available to both the SQL Server relational database engine and Analysis Services. A vast library of events are available to specific sessions which can be saved, scheduled and then analyzed to support performance tuning, troubleshooting and general monitoring. However, similar to other monitoring tools such as Windows Performance Monitor and SQL Server Query Store, the Extended Events graphical interface lacks the rich analytical capabilities and flexibility of tools such as Power BI; these are often necessary, or at a minimum helpful, to generate insights from this data.
In this recipe, the output of an Extended Event session containing query execution statistics is retrieved into a dedicated Power BI event analysis report file. The 1.4 million...