We need the ability to see the query plan. A visual query plan like you can get in Synapse or an EXPLAIN plan like in Synapse would be acceptable. This can help us troubleshoot slowly performing queries. I would very much like to see estimated row counts and such to know whether the optimizer has chosen a silly plan.
3 Comments
- fbcideas_migusrNew MemberStatus added:Under Review
- Mariyaali
Microsoft Employee
Status changed:Under ReviewtoCompletedSHOWPLAN_XML is now generally available!
- Mariyaali
Microsoft Employee
Status changed:Under ReviewtoCompleted
Recent ideas
Power Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes2 hours agoNew MemberNeed Clarification202Views3likes2CommentsMake Copilot Approval status for semantic model available through API
In recent versions fabric allowed to mark a semantic model as approved for copilot to reduce AI adoption friction. However there is no specific way for external governance application to analyse whi...FrançoisD2 hours agoFrequent VisitorNew6Views0likes0CommentsClone a workspace, including its data, to a new workspace
Description: Today there's no way to fully clone a Fabric workspace: git sync and Deployment Pipelines move item definitions only, not the underlying data; Warehouse's zero-copy CREATE TABLE ... AS ...gclements3 hours agoHelper IINew12Views1like0CommentsAllow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara9 hours agoNew MemberNew8Views0likes0CommentsSupport Synonyms in Fabric Warehouse
Microsoft SQL Server has a very powerful feature by the way of "synonyms." It allows users and DBAs to do all sorts of powerful magic such as rewiring objects under the hood (e.g. run the code agains...matthias-bi12 hours agoRegular VisitorNew1.3KViews18likes2Comments