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

yehong's avatar
yehong
Power BI Team
7 years ago

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.

joshbrownwsna's avatar
joshbrownwsna
Frequent Visitor
7 years ago

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.net

 

Josh