Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Desktop Get Data from ADLS Gen 2

We're currently using Azure Data Lake Store Gen 1 and are looking to transition to ADLS Gen 2.  Our data lake is solely used by Power BI Pro authors.  However, for the life of me, I can't figure out ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Maggie.  Is there a plan to add direct support to Azure Data Lake Storage Gen2 from Power BI or Azure Analysis Services?

  • admin_xlsior's avatar
    admin_xlsior
    Post Prodigy
    7 years ago

    It has now with Power BI July 2019 updates.

    But as I try to use it, because in Power BI ideas said it is direct connection, so I just paste it the URL of my ADLS2 path, sign in to my organization account  which the same account as the one create the ADLS2 folder, but it give me error.

     

    Here is my steps result the error :

    1. From Azure  portal, storage explorer, go to property of my ADLS Gen 2 storage account. Copy the URL.

     

    2. Paste it in Get Data -> Azure -> Azure Datalake Sstorage Gen2 URL path 

     

    3. Sign in 

     

    4. Error appeared after click connect saying couldn't authenticate.

     

    Thanks,

     

     

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, 

      you can try the following steps:

       

      1. Get the URL from Storage explorer (I used the local installation):

       

      2. Paste the adress for ADLS2 Connector and use the key for authentification (otherwise you have to give your account permissions).

       

       

      3. Get the key from the azure storage explorer

       

       

      Cheers

      Alex