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
Hi Yehong,
Allright clear!
I managed to try it with Global Administrator rights (on the same account), but still have little success:
Something went wrong
Error while connecting your Data Lake Storage account
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 2aa13457-2360-47d0-8bda-0ff8e6cb0428
Request ID: 74af588b-63d5-f31f-6874-42cf4fac39d9
Correlation ID: fb58b233-080f-9204-0875-2a61b82356ae
Time: Thu Dec 20 2018 15:29:33 GMT+0100 (West-Europa (standaardtijd))
Version: 13.0.7683.188
Cluster URI: https://wabi-west-europe-b-primary-redirect.analysis.windows.net
It shows me the 'almost done' message before displaying the error. (This wasn't the case before, but not sure whether that makes a difference?)
Thanks!
Same here - updated the Azure Storage Explorer, was able to assign all accesses to the object ids as directed.
Still get this same message from Power Bi:
Please try again later or contact support. If you contact support, please provide these details.
Hi healthEteam,
From looking at your traces it seems that that storage account is not located at the same region of your tenant. From the setup manual, "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."
Can you please tell if placing the storage in your tenant's storage solves the issue?
Both region are West US set since the beginning. Thanks.
xuanalytics, please note that my comment about incorrect region was directed to healthEteam.
We're still waiting for a response from Azure Storage team for your issue (you managed to attached storage but fail to create dataflows on top of it). Will update you once we reiceve their response.
