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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi all,

       

      Thanks! I can also confirm that this works for me! Great work!

      • BhaveshPatel's avatar
        BhaveshPatel
        Super User
        7 years ago

        Hi Anonymous,

         

        Can you please briefly explain what are the series of steps performed to make this work successfully.

         

        It would be really appreciated! I am trying all the recommended steps as explained by Michael7 but have no success.

         

        This would really assist me in debugging the process.

         

        Thanks,

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    7 years ago

    Hi Micheal,

     

    I managed to run the provided powershell script and the set up ran successfully. Set ACLs App has been successfully created and have Azure Storage Access on my data lake storage account as well as Read Permissions on the Azure Active Directory. I have added the objectId of this app to the powerbi folder on my storage account with full access.

     

    There is still an issue with connecting Dataflows to the Azure Data Lake Gen2 account.

    Error Message:

     

     

    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 IDbd89f749-7e02-4af5-9f24-8de3dd9f3b42
    Request IDf41b103f-e7fc-4694-a396-f82380a2fd90
    Correlation ID1af2a28f-91c3-565b-346b-0bfca13e556c
    TimeFri Jan 04 2019 11:21:04 GMT+1100 (AUS Eastern Summer Time)
    Version13.0.7683.237
    Cluster URIhttps://wabi-australia-east-a-primary-redirect.analysis.windows.net

     

     

     

    Can you please advise the solution for this.

     

    Thanks

    Bhavesh