Discover how to automate the creation of a baseline query performance in the lakehouse, reports to show the performance evolution and identify the source of the most demanding queries.

Fabric environment allow us to identify the report and visual responsible for each query. This is a kind of query lineage, allowing us to point exactly to where to fix when a query create problems in the lakehouse.

An automated system to extract query performance information allow us to keep track of the effects of every change made in our environment.

We can also identify the report and visual which are the source of the query using semantic kernel.