Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

DirectQuery: How to view generated SQL per visual, with row count and execution time?

I am working with a fairly complex (5 slicers, 13 visuals) Power BI report that is attached to an Azure SQL database via DirectQuery.


Currently, I am examining the generated SQL via the SQL Server Query Store, which works "ok", but one downside is, there's no way of knowing which visual corresponds to each SQL statement.


Is there an alternative approach to debugging SQL where I would be able to see this association, and hopefully still see row count and execution time per statement?

Community Support
Community Support



DAX Studio can be used to capture queries, you may have a look.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DAX Studio doesn't show which query belongs to which Visual though does it?

The only thing you could do is move each of your visuals to a page of their own. Now when you reopen your pbix file, the queries will be sent only for your active page, which could help you to debug and relate it to the corresponding SQL query/queries. 

Well sure, you can do that, but if you have a poorly performing piece of SQL that you notice executing on the backend, having to go through a trial and error process to find out which visual it belongs to is not a great use of a person's time.  Yes, I realize that based on the contents of the query you can very often (but not always!) narrow it down to a smaller subset of visuals to consider, but the point is, you shouldn't have to do this.  Microsoft devs control this entire stack, outputting the underlying visual with the SQL shouldn't be terribly technically difficult I wouldn't think.


Rumor has it this change is in the queue somewhere, so hopefully it isn't too far down the list.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors