Forum Discussion
PowerBI with Azure Data Lake Store
I would like to use an Azure Data Lake for a Power BI source as well. Any information on this would be appreciated.
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 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.
That's a very interesting solution. Thanks for sharing. Here's a question, are you able to refresh the data extracted from the datastore in the personal gateway?
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?
Not sure why we talk about ODBC here, since PowerBI has out of the box support for Azure Data Lake Store.
