Microsoft Fabric Connection With Multiple Warehouses

Pyramid analytics supports connecting to Microsoft Fabric as a data source.

The connection is made through a Microsoft Fabric Workspace, and the permissions to the Warehouses is managed by an App Registration on Azure.

If an App has access to all the Warehouses in the Workspace then the Pyramid data source will see all the Warehouses.

However, if the Azure App doesn't have permission to some of the Warehouses, you will need to create a separate Data source for each Warehouse by specifying its name on the connection details: