Uredi

Deli z drugimi prek


Azure Data Lake Storage Gen1

Note

On Feb 29, 2024 Azure Data Lake Storage Gen1 will be 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 prior to 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

Item Description
Release State General Availability
Products Excel
Power BI (Semantic models)
Analysis Services
Authentication Types Supported Organizational Account
Function Reference Documentation AzureStorage.DataLake
AzureStorage.DataLakeContents

Note

Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.

Prerequisites

Capabilities supported

  • Import
  • Advanced options
    • Page size in bytes

Connect to Azure Data Lake Storage Gen1

  1. Select the Azure Data Lake Storage Gen1 option in the Get Data selection, and then select Connect. More information: Where to get data

    Screenshot of the Get Data dialog box with the Azure Data Lake Store option highlighted and the Connect option called out.

  2. 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.

    Screenshot of the Azure Data Lake Storage Gen1 dialog box, with the URL entered.

  3. If this is the first time you're connecting to this database, select Sign in to sign into the Azure Data Lake Storage Gen1 account. You'll be redirected to your organization's sign-in page. Follow the prompts to sign in to the account.

    Screenshot of the sign in dialog box for Azure Data Lake Storage Gen1, ready to be signed in.

  4. After you've successfully signed in, select Connect.

    Screenshot of the sign in dialog box for Azure Data Lake Storage Gen1, with the user signed in and ready to connect.

  5. 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.

    Screenshot of the Navigator open and containing the data from the Drivers.text file.

Connect using 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.

See also