Connect Azure Data Lake Storage Gen2 for dataflow storage

You can configure Power BI workspaces to store dataflows in your organization’s Azure Data Lake Storage Gen2 account. This article describes the general steps necessary to do so, and provides guidance and best practices along the way. There are some advantages to configuring workspaces to store dataflow definitions and datafiles in your data lake, including the following:

  • Azure Data Lake Storage Gen2 provides an enormously scalable storage facility for data
  • Dataflow data and definition files can be leveraged by your IT department's developers to leverage Azure Data and artificial intelligence (AI) services as demonstrated in the GitHub samples from Azure Data Services
  • Enables developers in your organization to integrate dataflow data into internal applications, and line-of-business solutions, using developer resources for dataflows and Azure

To use Azure Data Lake Storage Gen2 for dataflows, you need the following:

  • Power BI tenant - at least one account in your Azure Active Directory (AAD) tenant must have signed up for Power BI
  • A Global Administrator account - this account is required to connect and configure Power BI to store the dataflow definition, and data, in your Azure Data Lake Storage Gen2 account
  • An Azure subscription - you need an Azure subscription to use Azure Data Lake Storage Gen2
  • Resource group - use a resource group you already have, or you can create a new one
  • An Azure Storage account with Data Lake Storage Gen2 feature enabled

Tip

If you don't have an Azure subscription, create a free account before you begin.

Warning

Once a dataflow storage location is configured, it cannot be changed. See the considerations and limitations section near the end of this article for other important elements to consider.

Prepare your Azure Data Lake Storage Gen2 for Power BI

Before you can configure Power BI with an Azure Data Lake Storage Gen2 account, you must create and configure a storage account. Let's take a look at the requirements for Power BI:

  1. You must be the owner of the ADLS storage account. This needs to be assigned at a resource level, not inehrited from subscription level.
  2. The storage account must be created in the same AAD tenant as your Power BI tenant.
  3. The storage account must be created in the same region as your Power BI tenant. To determine where you Power BI tenant is located, see where is my Power BI tenant located.
  4. The storage account must have the Hierarchical Name Space feature enabled.

The following sections walk through the steps necessary to configure your Azure Data Lake Storage Gen2 account in detail.

Create the storage account

Follow the steps in the Create an Azure Data Lake Storage Gen2 storage account article.

  1. Make sure you select the same location as your Power BI tenant, and set your storage as StorageV2 (general purpose v2)
  2. Make sure you enable the hierarchical namespace feature
  3. It is recommended to set replication setting to Read-access geo-redundant storage (RA-GRS)

Grant permissions to Power BI services

Next, you need to grant the Power BI service reader and data access roles in your created storage account. They are both built-in roles, so the steps are straightforward.

Follow the steps in Assign a built-in RBAC role.

In the Add role assignment window, select the Reader and Data Access role. Then use search to locate the Power BI Service application. Repeat the same steps for the Storage Blob Data Owner role, and assign the role to both the Power BI Service and Power BI Premium applications.

Note

Allow at least 30 minutes for permission for propagate to Power BI from the portal. Any time you change permissions in the portal, allow 30 minutes for those permissions to be reflected in Power BI.

Connect your Azure Data Lake Storage Gen2 to Power BI

Once you've set up your Azure Data Lake Storage Gen2 account in the Azure portal, you connect it to Power BI in the Power BI admin portal. You also manage Power BI dataflow storage in the Dataflow storage settings section of the Power BI admin portal. For guidance on launching and basic use, see How to get to the admin portal for detailed information.

You connect your Azure Data Lake Storage Gen2 account with the following steps:

  1. Navigate to the Dataflow settings tab of the Power BI admin portal

    Power BI admin portal

  2. Select the Connect your Azure Data Lake Storage Gen2 button. The following window appears.

    Azure Data Lake Storage Gen2

  3. Provide the Subscription ID of the Storage Account.

  4. Provide the Resource Group name in which the storage account was created.

  5. Provide the Storage Account name.

  6. Select Connect.

Once those steps are successfully completed, your Azure Data Lake Storage Gen2 account is connected to Power BI.

Note

To configure a connection to Azure Data Lake Storage Gen2 in the Power BI admin portal, you must have Global Administrator permissions. However, Global Administrators cannot connect external storage in the admin portal.

Next you need to enable people in your organization to configure their workspaces, which enables them to use this storage account for dataflow definition and data storage. Let's do that in the next section.

Allow admins to assign workspaces

By default, dataflow definition and data files are stored in the storage provided by Power BI. To access dataflow files in your own storage account, workspace admins must first configure the workspace to allow assignment and storage of dataflows in the new storage account. Before a workspace admin can configure dataflow storage settings, the admin must be granted storage assignment permissions in the Power BI admin portal.

To grant storage assignment permissions, go to the Dataflow settings tab in the Power BI admin portal. There is a radio button to Allow workspace admins to assign workspaces to this storage account which must be set to allow. Once you enable that slider, select the Apply button for the change to take effect.

Allow admins to assign workspaces

That's it. The Power BI workspace admins can now assign workflows to the file system you created.

Considerations and limitations

This feature is a preview feature, and its behavior may change as it approaches release. There are a few considerations and limitations to keep in mind when working with your dataflow storage:

  • Once a dataflow storage location is configured, it cannot be changed.
  • Only owners of a dataflow stored in Azure Data Lake Storage Gen2 can access its data by default. To authorize additional people to the dataflows stored in Azure, you must add them to the dataflow’s CDM folder
  • Creating dataflows with linked entities is only possible when they are stored in the same storage account
  • On-premises data sources, in Power BI shared capacities, are not supported in dataflows stored in your organization’s data lake
  • Snapshots are not deleted automatically on ADLS Gen 2. If you want to free up space you can create an Azure function to periodically clean up old snapshots.

There are also a few known issues, as described in this section.

Power BI Desktop customers cannot access dataflows stored in an Azure Data Lake Storage Account unless they are the owner of the dataflow, or have been authorized to the CDM folder in the lake. The scenario is as follows:

  1. Anna has created a new workspace and configured it to store dataflows in the organization’s data lake.
  2. Ben, who is also a member of the workspace Anna created, would like to leverage Power BI Desktop and the dataflow connector to get data from the Dataflow Anna created.
  3. Ben receives a similar error because Ben was not authorized to the dataflow’s CDM folder in the lake.

Common questions and answers include the following:

Question: What if I had previously created dataflows in a workspace and would like to change their storage location?

Answer: You cannot change the storage location of a dataflow after it was created.

Question: When can I change the dataflow storage location of a workspace?

Answer: Changing the dataflow storage location of a workspace is only allowed if the workspace does not contain any dataflows.

Next steps

This article provided guidance on how to connect an Azure Data Lake Gen2 for dataflow storage. For additional information, take a look at the following articles:

For more information about dataflows, CDM, and Azure Data Lake Storage Gen2, take a look at the following articles:

For information about dataflows overall, check out these articles:

For more information about Azure storage, you can read these articles:

For more information about the Common Data Model, you can read its overview article:

And you can always try asking questions of the Power BI Community.