Forum Discussion
Power BI Dataflow to Azure Data Lake Gen2 Setup
- 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_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
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?
- xuanalytics7 years agoFrequent Visitor
Both region are West US set since the beginning. Thanks.
- yehong7 years ago
Power BI Team
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.
- joshbrownwsna7 years agoFrequent Visitor
Hi Eveyone,
I tried again this morning just to make sure I am still getting the same error. I am and am in the same boat as xuanaltyics. Pasting it below incase its helpful for the storage team. Any help figuring this out is greatly appreciated! Thank you everyone for your time!
Something went wrong
Unable to save the dataflow.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: f617af12-4384-4fb6-a8e8-0a84bdfe0977
Request ID: 74bb234b-89de-4bf3-0fe9-2d062ed3d3e0
Correlation ID: 1b76189c-c3ae-ffd6-0ab6-1b5f7ad05176
Status code: 500
Time: Thu Dec 20 2018 09:23:56 GMT-0800 (Pacific Standard Time)
Version: 13.0.7683.188
Cluster URI: https://wabi-west-us-redirect.analysis.windows.netJosh