Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
On February 29, 2024, Azure Data Lake Storage Gen1 was retired. For more information, go to the official announcement. If you use Azure Data Lake Storage Gen1, make sure to migrate to Azure Data Lake Storage Gen2 before that date. To learn how, go to Migrate Azure Data Lake Storage from Gen1 to Gen2.
Unless you already have an Azure Data Lake Storage Gen1 account, you can't create new ones.
Summary
| Property | Value |
|---|---|
| Connector |  Azure Data Lake Storage Gen1 |
| Products | Excel Power BI (semantic models) Power Query Online |
| Release state | General availability |
| Category | Azure |
| Authentication kinds | Microsoft Entra ID |
| Data source kind | DataLake |
| Function Reference Documentation | DataLake.ContentsDataLake.Files |
Note
Some capabilities might be present in one product but not others due to deployment schedules and host-specific capabilities.
Prerequisites
An Azure subscription. Go to Get Azure free trial.
An Azure Data Lake Storage Gen1 account. Follow the instructions at Get started with Azure Data Lake Storage Gen1 using the Azure portal. This article assumes that you already created a Data Lake Storage Gen1 account, called myadlsg1, and uploaded a sample data file (Drivers.txt) to it. This sample file is available for download from Azure Data Lake Git Repository.
Supported capabilities
- Import
- Advanced options
- Page size in bytes
Parameters
Entry point: DataLake.Contents
Required parameter count: 1
Enter the URL of your Azure Data Lake Storage Gen1 account.
Returns a table containing a row for each folder and file found at url from Azure Data Lake Storage Gen1. Each row contains properties of the folder or file and a link to its content.
| Parameter | Display name | Required | Type | Group | Sample values | Nullable |
|---|---|---|---|---|---|---|
| url | URL | Yes | text | "swebhdfs://contoso.azuredatalake.net/" | false | |
| options | Options | No | nullable record | Options | true |
Fields in options
| Field | Display name | Required | Type | Group | Sample values | Nullable | Optional |
|---|---|---|---|---|---|---|---|
| options.PageSize | Page Size in Bytes | No | number | Options | 8388608 | false | true |
Connect from Power Query Desktop
Select the Azure Data Lake Storage Gen1 option in the Get Data selection, and then select Connect. More information: Where to get data
In the Azure Data Lake Store dialog box, provide the URL to your Data Lake Storage Gen1 account. Optionally, enter a value in Page Size in Bytes. Then select OK.
If you're connecting to this database for the first time, select Sign in to sign into the Azure Data Lake Storage Gen1 account. You're redirected to your organization's sign-in page. Follow the prompts to sign in to the account.
After you successfully sign in, select Connect.
The Navigator dialog box shows the file that you uploaded to your Azure Data Lake Storage Gen1 account. Verify the information and then select either Transform Data to transform the data in Power Query or Load to load the data in Power BI Desktop.
Additional information
Advanced options
Power Query provides an advanced option that you can add to your query if needed.
| Advanced option | Description |
|---|---|
| Page Size in Bytes | Used to break up large files into smaller pieces. The default page size is 4 MB. |