[BUG]-The MCP server cannot query SQL Endpoints of Lakehouse #2298
Description
Describe the bug
show me top 2 rows in dimcustomer_gold table using SQL endpoint. Dont download parquet files
Fabric MCP: let me query directly via the SQL endpoint instead.
Execute SQL Query on Fabric Lakehouse
Result
Done
The schema-qualified query is failing — this Lakehouse has schemas enabled, which the fabric_query_lakehouse tool doesn't support via the standard SQL endpoint. We confirmed this earlier when the same issue occurred with factsales_gold. The tool uses the Spark SQL / TDS endpoint which doesn't resolve the sales. schema prefix for this particular lakehouse.
Expected behavior
I expect that SQL Endpoints are querable and return data from lakehouse tables - whether schema enabled or not.
Actual behavior
The schema-qualified query is failing — this Lakehouse has schemas enabled, which the fabric_query_lakehouse tool doesn't support via the standard SQL endpoint. We confirmed this earlier when the same issue occurred with factsales_gold. The tool uses the Spark SQL / TDS endpoint which doesn't resolve the sales. schema prefix for this particular lakehouse.
Reproduction Steps
Simply say show me top 3 rows in mytable from mylakehouse
Environment
Claude Desktop + Macbook