Forum Discussion

b5lurker's avatar
b5lurker
Advocate II
7 years ago
Solved

Power BI Dataflow to Azure Data Lake Gen2 Setup

Excited to see all of the new Power BI Dataflow capabilities especially with using Azure Data Lake Gen2 as the storage location for those Dataflows.   But, I have been trying to get it setup using ...
Need Help
  • Michael7's avatar
    Michael7
    7 years ago

    Hi,
     
    There is a temporary issue with settings ACLs through Microsoft Azure Storage Explorer, until this is resolved, as a temporary mitigation you can try using this powershel script:https://setacls.blob.core.windows.net/scriptfolder/setacls.ps1
     
    In order to run the script, your global tenant admin needs to have "Storage Blob Data Contributor (Preview)" role on your storage account.
     
    Instructions on how to run this script:
        
    1. Login as global tenant administrator into Azure portal and open PowerShell (Cloud Shell) in your browser
    2. Choose Azure CLI 2.0 (type ‘az’)
    3. Upload the script (there is a button for it)
    4. Run the script. For example:  /home/admin/setacls -storageaccountname your_alds_gen2_storage_account_name

     

    The script will ask you to sign in, please follow the instructions.
     
    Thanks,
    Michael

     

     

    Hi,

     

    There is no more need in this workaround, please use ASE 1.6.2 which is availably for update and download.

     

    Thanks,

    Michael

joshbrownwsna's avatar
joshbrownwsna
Frequent Visitor
7 years ago

Hi Ben,

 

Thank you for your reply.  Unfortunately, I linked my power bi account before finding this post. While we have linked the power bi account, we have not configured any of our app workspaces to use the linked storage account. Will using dataflows like this cause us issues or will our flows continue to populate the Power BI storage?

 

Is there any way in Power BI to unlink the account?  There does not seem to be a setting to do so in the Power BI interface.

 

Josh

joshbrownwsna's avatar
joshbrownwsna
Frequent Visitor
7 years ago
Hi Everyone,

Posting in case anyone has linked their account before they have the ACLs in place as I have. I can answer the questions I posed above.

As I noted above I had linked our Powr BI account to our gen 2 storage account before I found this thread. However, since we had not enabled any of our workspaces to use the data lake storage account, our exiisting Dataflows have continued to write to the Power BI storage.

Said another way using Dataflows with Data Lake storage takes 5 steps:

1. Create a Gen2 Storage account
2. Configure the storage account so that the Powe BI service (power query, power bi service, power bi premium) can read and write to the storage account. This is done in Azure and the storage explorer (once it’s updated).
3. Use the admin panel in Power Bi web app to Enable/link your Power BI instance to the storage account.
4. Use the admin panel in Power BI to provide workspace admins the ability to use datalake storage for their Dataflows.
5. Use the Power BI web app to enable the use of Datalake storage for dataflows in for each workspace

Unless all of these steps are done the data flow will continue to use the internal power bi storage.

Hope that’s helpful to others. This is all laid out in the different pieces of documentation, however, it’s not as clear if you start out from the Powe BI admin panel. If I’m in correct please let me know!

Josh