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
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

"Querying Data in Azure Data Lake Store with Power BI"  only applies to Azure Data Lake Storage Gen1.

Direct support from Power BI (or Azure Analysis Services) is not yet supported for Azure Data Lake Storage Gen2.

 

As searched, it seems possible to use ADLS Gen 2 as Azure SQL DataWarehouse External Data Source.

Please check 

"How to use data stored in ADLS Gen 2"

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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