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 sour...
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.

jefflaw's avatar
jefflaw
Frequent Visitor
9 years ago

If I have to use an ODBC data source as I want to publish, is there any reference as to how to set this up?

  • DrGigabit's avatar
    DrGigabit
    Regular Visitor
    9 years ago

    Not sure why we talk about ODBC here, since PowerBI has out of the box support for Azure Data Lake Store.

    • jefflaw's avatar
      jefflaw
      Frequent Visitor
      9 years ago

      It was a follow up to desertislesql post above in this thread...

      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.

       

      I am testing out PowerBI with our AppInsights data. One of the options is to move the data into DataLake and use that as a source. I can access everything fine from PowerBI, but when I publish, the connection doesnt work. I keep getting prompted to login.

       

      Doing a search, I found this reference which aligns with my experiance. Having gotten the data into DataLake, I am trying any option I can find to get the data into PowerBI.

       

      I would have thought using ODBC was a bit of hack, and if there is a way to get this working "natively" then I would like to use it.