Warehouses
Connect Microsoft Fabric
Connect a Fabric warehouse or a lakehouse's SQL analytics endpoint as a Microsoft Entra service principal with read access only.
The Microsoft Fabric connector signs in to one Fabric warehouse, or one lakehouse's SQL analytics endpoint, as a Microsoft Entra service principal.
Availability. The Microsoft Fabric connector must be on for your workspace. See Connect a data warehouse.
Set up the service principal
- In the Microsoft Entra admin center, open App registrations and register an app for Ahamo. Under Certificates & secrets, add a client secret. Note the Application (client) ID and the Directory (tenant) ID.
- In the Fabric admin portal, under Tenant settings › Developer settings, let service principals use Fabric, for a security group that holds the app.
- Give the app read access only, in one of two ways:
- the workspace's Viewer role, which reads every warehouse and SQL endpoint in it;
- or share only the item with the app, with Read all data using SQL and nothing else.
- Copy the server from the item's SQL connection string, such as
….datawarehouse.fabric.microsoft.com, and note the warehouse or lakehouse name.
Contributor, Member and Admin can write. When you connect, Ahamo checks that a write is refused, and refuses an app that can write. To keep a table out, use DENY SELECT ON <schema or table> TO [ahamo-reader] inside the item, with the app's own name.
Connect
- Open Connectors, find Microsoft Fabric and choose Connect.
- Enter the server, the warehouse or lakehouse name and the Microsoft Entra tenant ID.
- Paste the app's Application (client) ID and the secret's value. Ahamo keeps the secret encrypted and never shows it again.
- Name the connection, choose who may use it, and choose Test and connect.
A lakehouse's tables are dbo.<table>, and a warehouse's are <schema>.<table>. Statements run as for SQL Server, with the same limits.
If your tenant limits which addresses may reach Fabric, allow Ahamo's fixed address. The SQL Server connect dialog shows it.
Troubleshooting
Microsoft Entra didn't accept the client ID and secret. Paste the Application (client) ID and the secret's value, not its ID, and check the tenant ID.
Fabric didn't let the service principal in. Give the app access to this workspace or item, check the warehouse name, and ask a Fabric admin to allow service principals.
This service principal can change data, so Ahamo doesn't connect with it. Give it only the workspace's Viewer role or Read all data using SQL on the item.
Ahamo couldn't reach the warehouse. Copy the server from the item's SQL connection string.
Fabric no longer accepts this connection's secret. The client secret expired. Add a new one to the app and paste it with Paste a new key.