DW Execution plan

Question

Is there a reason why Execution plan is not visible; same happens for Actual Execution Plan, Live Statistics, Estimated plan.
&nbsp;
I have tested this on both DW and Lakehouse tables and in both cases this happens.

&nbsp;

andyddc · Answer

Hi&nbsp;smpa01&nbsp;currently there is no execution plan available in the Fabric Warehouse or Lakehouse SQL Endpoint service. &nbsp;I believe MS are looking at ways to expose certain information.

anonymous · Answer

HI&nbsp;smpa01,
You can also take a look at the following link about the SQL endpoint and data warehouse T-SQL query usage limitations:
T-SQL surface area - Microsoft Fabric | Microsoft Learn
Regards,
Xiaoxin Sheng

Forum Discussion

DW Execution plan

2 Replies

Related content

Any plan to Discontinue PBIRS

Fabric DW from SQL server

Execution plans in Fabric Warehouse or Lakehouse

Parallel Execution

Fabric Python Notebook Execution Logs