Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
I have performance problems with queries on Fabric Warehouse and Lakehouse which I don't experience on synapse serveless sql pools.
I would like to analyze query execution plans on sql server management studio I get this error:
Microsoft SqlClient Data Provider Framework: Message 15869, Level 16, State 3, Line 1
SHOWPLAN_XML is not supported for SET.
Do you have any ideas?
Thank you
Solved! Go to Solution.
Hi @marcoG ,
At this time, SHOWPLAN_XML/EXPLAIN statements are not supported by Microsoft Fabric DW.
Currently, there are plans to expose the query plan in query insights view.
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.
Hi @marcoG ,
We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.
Hi @marcoG ,
At this time, SHOWPLAN_XML/EXPLAIN statements are not supported by Microsoft Fabric DW.
Currently, there are plans to expose the query plan in query insights view.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
User | Count |
---|---|
8 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 |