Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin the OneLake & Platform Admin teams for an ask US anything on July 16th. Join now.
Hi - I'm curious to know if there is any way to see an "explain plan" or otherwise determine why a SQL query against a Lakehouse is taking a long time, and what could be done to help it. In my case I tried a sample query that queried a table with about 1 billion rows by it's primary key column, sorting the keys in ascending order. I realize sorting 1 billion values should take "a long time" - but I'm unsure that 11 minutes is expected / acceptable.
Note: yes this is an extreme and unrealistic case, in my case this was a proxy query that should have similar costs to the query the user actually wanted to run (but couldn't due to me not having the needed column)...
Long and short - what tools are available to understand the performance and potentially help it.
Thanks,
Scott
Thanks for using Microsoft Fabric Community.
Apologies for the issue you are facing here.
Microsoft Fabric Data Warehouse currently doesn't offer native "explain plan" functionality like SHOWPLAN_XML or EXPLAIN for SQL queries and there are plans to expose the query plan in a "Query Insights" view. However, there are still ways to understand the performance of your query and potentially improve it:
1. Data Preview and Query Insights:
You can refer to this link for more information.
2. Monitoring and Metrics:
Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.
Hope this helps. Please let me know if you have any further queries.
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.
Thanks
hi @v-cboorla-msft in my case I was specifically talking about a Lakehouse not a Warehouse (using the SQL endpoint). I'll try a similar test on a Warehouse to see if that makes a difference. Overall I'm just really trying to judge the performance to see if it's reasonable or not.
Thanks!
Scott
Following up to see on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.
Thanks
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.