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

Hi xuanalytics - are you seeing the failures in PowerBI portal? can you please share the "Something went wrong" message contents?

xuanalytics's avatar
xuanalytics
Frequent Visitor
7 years ago

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's avatar
    yehong
    Power BI Team
    7 years ago

    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.