Forum Discussion

hubix2000's avatar
hubix2000
New Member
10 years ago

PowerBI with Azure Data Lake Store

Hi,

 

we already run all our operations on Azure SQL databases. Now we are going to invest into Azure Data Lake Store and like to integrate it with PowerBI. Currently there is no external data source to ADLS available.

 

Can you provide us an estimate roughly when a beta phase might start and if the external data source will support direct query?

 

Best Regards

Jörg

12 Replies

  • desertislesql's avatar
    desertislesql
    Most Valuable Professional
    10 years ago

    I would like to use an Azure Data Lake for a Power BI source as well. Any information on this would be appreciated.

    • desertislesql's avatar
      desertislesql
      Most Valuable Professional
      10 years ago

      I found out that ir you are looking to use an Azure Data Lake as your data store, you cannot directly connect to it online. If you want to use an Azure Data Lake as a data source, you will need to use an ODBC data source in Power BI Desktop.

      • gerardcuijpers's avatar
        gerardcuijpers
        New Member
        10 years ago

        I managed to get data from a Data Late Store into PowerBI desktop, but not the way I would like it:

        • PowerBI Desktop, Version: 2.32.4307.641 64-bit (February 2016)
        • Get Data / Azure / Microsoft Azure Data Lake Store (Beta)
        • Provide the adl:// or swebhdfs:// path
        • It will show you a preview with columns like "content, name, extension, .."
        • Click on "Edit"
        • Click on the link "Binary" in the first column ("Content")
        • Now you can see the the data as it appears in the file itself.