Forum Discussion
Advocate IIPower 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 Everyone,
I was also able to add the ACLs using the internal build. In addition, since my account was already connected, I was able to work through all the steps in the configuration document.
I also created a new workspace and was able to configure the workspace to use data lake storage.
Please note, this option is only available in workspaces created to view the new experience. If your workspace has been created via an O365 group, you will not be able to configure it to use data lake storage.
Unfortunately, when I try to save a workflow I get the following error:
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: 6cf62757-8eed-4c8f-b89a-19e737873a62
Request ID: 4ebf59ad-5980-ed22-5432-3f2915ef5446
Correlation ID: 1f1bbc99-c76b-8c1b-54af-aaa270b10656
Status code: 500
Time: Fri Dec 14 2018 22:07:33 GMT-0800 (Pacific Standard Time)
Version: 13.0.7683.181
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net
So, unfortunately, no dice ... yet. But progress!
Thanks to everyone for the help. This has been a great thread!
*** Update 12/16/18 ***
Hi Everyone,
Double checked my config tonight against the instructions laid out in https://docs.microsoft.com/en-us/power-bi/service-dataflows-connect-azure-data-lake-storage-gen2. Noted my config appears correct, but still getting the 500 error. Any help in review would be appreciated!
Josh
Hi Josh,
I am getting the exact same error as you got. I configured everything according to the Microsoft document. But I am not able to save any data flow in the new app workspace which Data Lake Storage enabled. I have then checked teh activity log of the storage account and I found everytime I am trying to save it
yehongPower BI Team
Hi xuanalytics - are you seeing the failures in PowerBI portal? can you please share the "Something went wrong" message contents?
Hi yehong, yes, I got it from PowerBI portal and it is the same error as Josh got. Here is the information.
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: d33a532d-45eb-4d65-9b7a-f7041b3cd1a8
Request ID: 9135fad1-a6f5-c6f9-e204-165cfd0e48ba
Correlation ID: c7c3a7ba-233c-8e8f-1139-28bbb6935973
Status code: 500
Time: Thu Dec 20 2018 07:55:02 GMT-0500 (Eastern Standard Time)
Version: 13.0.7683.188
Cluster URI: https://wabi-us-west2-redirect.analysis.windows.net- yehong
I see Authorization errors on storage (the spikes you've shared before), since you confirmed that you've set up the storage according to documentation, I'll be reaching out to storage team to understand the issue.