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

Picci's avatar
Picci
Helper I
7 years ago

Hi yehong, what about changing the ADLS Gen2 account to be associated with Power BI?

What about if I need to move my storage account to another subscription?

 

Thanks,

Elisa

yehong's avatar
yehong
Power BI Team
7 years ago
You can move the storage account between subscriptions and resource-groups as long as it's kept under the same tenant.
  • Picci's avatar
    Picci
    Helper I
    7 years ago
    yehong thanks for your reply, is it possible to do it from the Power BI Service Admin Portal? At the moment I'm not able to change what I specified in Dataflow storage (preview) under https://app.powerbi.com/admin-portal/dataflows. Thanks again, Elisa
    • yehong's avatar
      yehong
      Power BI Team
      7 years ago
      At the moment we're not caching the subscription id and resource-group name therefore there is no action you should take in Power BI portal. Please note that the storage should be kept under the same tenant.
      • Picci's avatar
        Picci
        Helper I
        7 years ago
        Ok, just to see if I've understood correctly: I can move the ADLS2 storage to another subscription and resource group, as far as: - they are under the SAME tenant - the ADLS2 storage name remains the SAME In the future it will be possible to unlink/link storage accounts? Or to have more than one storage account to manage (and then decide from time to time which storage account to link to which Power BI Workspace)?