Two DWHs in same layer but different workspaces

Hi fabricpribeiro ,

Thanks for reaching out to Microsoft Fabric Community.

Thanks to Pragati11 and tayloramy  for sharing your valuable inputs.

Just to clarify how this maps to current Fabric behavior: cross-warehouse SQL queries and views are supported when the warehouses are in the same workspace. Direct SQL references across warehouses that live in different workspaces are not supported in Fabric Data Warehouse.

References:
Query the SQL Analytics Endpoint or Warehouse - Microsoft Fabric | Microsoft Learn
Data Warehouse Tutorial: Create a Cross-Warehouse Query in a Warehouse - Microsoft Fabric | Microsoft Learn

As mentioned by tayloramy , a supported way to work around this is to use OneLake shortcuts to bring data from another workspace into a lakehouse in your workspace, and then use that lakehouse as the source for cross-database queries within the same workspace.

Similar threads for reference:

Solved: Cross workspace lakehouse/warehouse queries do not... - Microsoft Fabric Community

Solved: Cross Workspace access - Microsoft Fabric Community

Solved: Creating Warehouse Shortcuts - Microsoft Fabric Community

If the reuse requirement is mainly at the reporting layer, the option mentioned by Pragati11  around centralized or endorsed semantic models also fits within what Fabric supports today.

Hope this helps clarify.

Please reach out for further assistance,
Thank you.