Forum Discussion

b5lurker's avatar
b5lurker
Icon for Advocate II rankAdvocate 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

b5lurker's avatar
b5lurker
Icon for Advocate II rankAdvocate II
7 years ago

I was able to get my login setup with the Global Admin role and after I signed out of Power BI and signed back in with the credentials that have been attached to the Global Admin it sat on the Almost Done message for quite a bit longer then it has before, but still ended up with the "Something went wrong" message. Below are the error details:

 

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: a2de8002-2fa2-45f1-bc6f-50d8403a4b9d
Request ID: c895f191-8ad8-79a9-bc46-27e9c6495712
Correlation ID: 14645bcf-3862-8786-24de-b0d03a3f5946
Time: Thu Dec 20 2018 08:32:25 GMT-0700 (Mountain Standard Time)
Version: 13.0.7683.188
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net

 

As far as I know I have the powerbi blob container and security all setup for the Power BI Service, Power BI Premium and Power Query Online application Object IDs, so not sure what else is missing to get this working. I have also setup the ADLSg2 resource in the West US region, so it is in the same region as our Power BI tenant now.

 

Thanks,

Steve

yehong's avatar
yehong
Icon for Power BI Team rankPower BI Team
7 years ago

Hi Steve, from looking at your traces it seems that you're hitting the same issue as lhanegraaf. We're waiting for response from Azure Storage team and will update you.