Edit

Integrate OneLake with Azure Storage Explorer

  • Article

This article demonstrates OneLake integration with Azure Storage Explorer. Azure Storage Explorer allows you to view and manage your cloud storage account’s contents. You can upload, download, or move files from one location to another.

Connect and use Azure Storage Explorer

  1. Install the latest version of Azure Storage Explorer from the product webpage.

  2. Check to ensure the version installed is 1.29.0 or higher. (Check the version by selecting Help > About.)

  3. Select the Open connect dialog icon.

    Screenshot showing where to select the Open connect dialog icon.

  4. Azure Storage Explorer requires you to sign in to connect to Azure resources. Select Subscription and follow the instructions to sign in.

    Screenshot showing where to select Subscription on the Select resource screen.

  5. Connect to OneLake by selecting the Open connect dialog icon again and select ADLS Gen2 container or directory.

    Screenshot showing where to select the Azure Data Lake Storage (ADLS) Gen2 container or directory option.

  6. Enter URL details of the workspace or item you would like to connect to, in this format: https://onelake.dfs.fabric.microsoft.com/{workspace-Name}/{itemName.itemType}/. You can find the workspace name and item name in the Properties pane of a file in the Microsoft Fabric portal.

    You can choose a Display name for convenience, then select Next.

    Screenshot showing where to enter a display name.

  7. Storage Explorer browses to the location of the OneLake you entered.

    Screenshot showing an example of a OneLake selection in Azure Storage Explorer.

  8. To view the contents, select the OneLake folder you connected.

    Screenshot showing where to select your connected folder.

  9. Select Upload. In the Select files to upload dialog box, select the files that you want to upload.

    Screenshot showing where to select Upload or Download.

  10. To download, select the folders or files that you want to download and then select Download.

  11. To copy data across locations, select the folders you want to copy and select Copy, then navigate to the destination location and select Paste.

    Screenshot showing where to select Copy or Paste.

Limitations

If a workspace name has capital letters, deletion of files or folders fails due to a restriction from the storage service. We recommend using your workspace name in lowercase letters.

Related content