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

sagivh's avatar
sagivh
Microsoft Employee
7 years ago

Hi everyone, we acknowledge the reported setup issues. we have found a potential issue in Azure Storage Explorer and are working on a mitigation. 

We will update this post when we have more information and ETA. 

 

Thank you. 

RyanTheDataBus's avatar
RyanTheDataBus
New Member
7 years ago

Hi,

 

I'm having the same issue.  Looking forward to any help you can provide.

 

Cheers,

Ryan

 

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: 20b9daf2-da0e-4dc0-a266-b8aecd433a94
Request ID: c86756c0-210b-13ec-23a6-a1ea7d6de12e
Correlation ID: afa24dbe-d215-d05f-12e4-ae9ae7fa3c46
Time: Fri Dec 28 2018 13:27:05 GMT-0800 (Pacific Standard Time)
Version: 13.0.7683.188
Cluster URI: https://wabi-us-north-central-b-redirect.analysis.windows.net

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    Same issue here :(

     

    Error:

     

    Activity ID7ae90109-cd7f-4caf-a342-0a0c1700a3b3
    Request ID9385312a-6d0c-133b-4530-72f88ad0bbbb
    Correlation IDd36f7917-72d5-f8dc-5567-7a220a6c640f
    TimeSat Dec 29 2018 17:21:23 GMT+0000 (Western European Standard Time)
    Version13.0.7683.237
    Cluster URIhttps://wabi-west-europe-redirect.analysis.windows.net

    • Michael7's avatar
      Michael7
      Frequent Visitor
      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
        Advocate II
        7 years ago

        I can confirm that I was able to run these steps and get the Dataflows setup with our ADLSg2 Data Lake in Azure! :)

         

        Thanks, now I can start to play with this new feature! :)

         

        Steve

    • Michael7's avatar
      Michael7
      Frequent Visitor
      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.

       

      In order to update:

       

      For download: https://go.microsoft.com/fwlink/?LinkId=708343

       

      Thanks,

      Michael