Configuring an ADF Linked Service Connection for Fabric Lakehouse
For information on how to enable a connection for use with linked services, see Configuring a Linked Service Connection.
Field labels in this walkthrough follow the underlying Azure Data Factory property names, with the connection column that carries each value named alongside. The exact labels shown in the BimlFlex Connection Editor may differ.
In an Azure Data Factory project, a connection enabled for linked services with the System Type Fabric Lakehouse builds an Azure Data Factory Lakehouse linked service for the Lakehouse, together with its table datasets, copy sources and copy sinks.
The connector uses the same Fabric Lakehouse System Type that a Microsoft Fabric project uses.
In a project configured for Microsoft Fabric, a Fabric Lakehouse connection follows the Fabric build described in the Microsoft Fabric Configuration Overview. The linked service fields on this page apply to Azure Data Factory projects.
Datasets, Sources and Sinks
The Lakehouse table dataset takes the schema and the table from the TargetSchemaName and TargetObjectName parameters, in the same shape as the Azure Synapse Analytics dataset.
The Biml Lakehouse table dataset treats the schema as optional, and BimlFlex supplies it from the TargetSchemaName parameter.
The copy source is a Lakehouse table source. It reads the Lakehouse table directly and takes no source query.
When the copy lands data in a Fabric Lakehouse connection, the copy sink is a Lakehouse table sink that writes to the landing dataset.
Authentication Method
| Method | Credentials | Additional Settings |
|---|---|---|
| Service Principal | Service Principal Id, Service Principal Key and Tenant | None |
Recommendation: Store the Service Principal Key in Azure Key Vault rather than entering it as plaintext.
Complete Example: Service Principal with Azure Key Vault
| Field | Example Value |
|---|---|
| Connect via Integration Runtime | AutoResolveIntegrationRuntime |
| External Reference | {Lakehouse Id} |
| Service Principal Id | {Application (Client) Id} |
| Tenant | {Tenant Id} |
| Azure Key Vault Linked Service | bfx-kv |
| Secret Name (for Service Principal Key) | BFX-FabricLakehouse-ServicePrincipalKey |
Required Fields
The required fields for a Fabric Lakehouse Linked Service connection are:
- Connect via Integration Runtime
- External Reference
- Service Principal Id
- Service Principal Key (or Azure Key Vault)
- Tenant
The Workspace Id comes from the FabricWorkspaceId setting rather than from a connection field.
Connect via Integration Runtime
Connect via Integration Runtime names the integration runtime for a Fabric Lakehouse Linked Service connection.
The default value is AutoResolveIntegrationRuntime.
To use another runtime, select it from the dropdown or choose + New to add one.
When a custom value is saved in the linked service form, it will be added to the custom integration runtimes.
The custom values that appear in this dropdown can be maintained in Settings under Azure - AzureIntegrationRuntime.
Workspace Id
The Workspace Id identifies the Microsoft Fabric workspace that holds the Lakehouse.
It comes from the FabricWorkspaceId setting and maps to the ADF workspaceId property.
The connection carries no separate workspace field.
External Reference
The External Reference identifies the Lakehouse within the workspace.
It is the connection's External Reference field, entered as described in External Reference, and maps to the ADF artifactId property.
Service Principal
The Fabric Lakehouse Linked Service connection authenticates with a service principal.
The generated linked service carries the Authentication Type ServicePrincipal.
The Service Principal Id supplies the client id and is stored in the connection's LS_ServicePrincipalId column.
The Service Principal Key supplies the client secret as plaintext in the LS_ServicePrincipalKey column, or as an Azure Key Vault reference held in the LS_ServicePrincipalKeyKVS_ fields that resolves to the secret at runtime.
The Tenant is stored in the connection's LS_Tenant column and maps to the ADF tenant property.
It is suggested that Azure Key Vault be used in place of manually entering the Service Principal Key.
Azure Data Factory Linked Service Additional Information
For additional information on ADF Microsoft Fabric Lakehouse Linked Service and its connection requirements see the Azure Data Factory Microsoft Fabric Lakehouse Connector documentation.