Lakehouse Location

This file location type enables access to files that are stored in an Azure Fabric Lakehouse.

The following file types are supported. Click to jump to the related documentation.

• CSV
• MS Excel
• JSON
• ParquetFile
• Qlik QVX
• Tableau HYPER
• XML

Lakehouse files can be accessed for extracts and loads. Note that MFA (Multi Factor Authentication) is not supported.

To access Lakehouse, a valid oAuthToken connection is needed with the scope 'https://storage.azure.com/.default'.

Type	FabricLakehouse
File name	The name of the file in Lakehouse. Use relative paths for files that are located within folders.
Token connection	An OAuth Token connection is required. See OAuthToken Connection for details. The endpoint in OAuthToken connection should be configured this way: Token endpoint: https://login.microsoftonline.com/{tenant id}/oauth2/v2.0/token Access token scope: 'https://storage.azure.com/.default'
Azure application ID	The application ID in Azure Active Directory (also called App-ID or Client-ID). This ID must be obtained from your IT department.
Workspace name	Name of the Fabric Workspace where the Lakehouse is located.
Document library	Name of the Lakehouse.

Updated August 28, 2026