Forum Discussion
Cross-Database Queries Don't Work As Documented
The Microsoft documents at these two links both indicate that cross-database queries should be supported by the Fabric SQL Database Preview, through 3-part identifiers. However when I try this in pra...
Cross-database queries in Microsoft Fabric SQL Database only work via the SQL Analytics Endpoint and within the same workspace, using three-part names (e.g., Database.Schema.Table). They do not work when connecting directly to an individual SQL database, which causes the errors you see. No special configuration or regional setting is required make sure you're querying from the SQL Analytics Endpoint, and all referenced databases/warehouses are in the same workspace.