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
I surely checked several times that I followed all steps to connect my ADLS gen 2 to Power BI, but I still get no success. 
  1. I made sure the ADLS is in the same location then my PBI tenant (in my case North Europe)
  2. I give the PBI Service access with the reader role
  3. I give PBI Svc and Power Query full access to the container folder "powerbi"
  4. I even tried full access to all 

any suggestion why I still get no success?

 

Aktivitäts-ID14edddab-cb86-48c7-9ce4-6ffc3e48c1ac
Anforderungs-ID7eb3a30d-892c-c8fc-a5ba-018643494695
Korrelations-IDac823118-22e0-3bc8-a0fb-60d41fde1b62
ZeitFri Dec 21 2018 12:54:24 GMT+0100 (Mitteleuropäische Normalzeit)
Version13.0.7683.188
Cluster-URIhttps://wabi-north-europe-redirect.analysis.windows.net
 
  • julioleite's avatar
    julioleite
    Regular Visitor
    7 years ago

    I am with the same issue. Checked the points several times and got the error.

     

     

     

    • 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