Forum Discussion
Power BI Dataflow to Azure Data Lake Gen2 Setup
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_nameThe script will ask you to sign in, please follow the instructions.
Thanks,
MichaelHi,
There is no more need in this workaround, please use ASE 1.6.2 which is availably for update and download.
Thanks,
Michael
Azure Storage Explorer 1.6.2 has been officially released https://docs.microsoft.com/en-us/azure/vs-azure-tools-storage-explorer-relnotes#version-162
Issues with ASE 1.6.1 are fixed with 1.6.2, please let us know of any issues you encounter with it during setup of storage with PowerBI as outlined here https://docs.microsoft.com/en-us/power-bi/service-dataflows-connect-azure-data-lake-storage-gen2
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
- You can move the storage account between subscriptions and resource-groups as long as it's kept under the same tenant.
- 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
