cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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 12
Highlighted
New Member

Re: PowerBI with Azure Data Lake Store

Hi,

 

any answer is welcome... 

 

Jörg

Highlighted
Helper III
Helper III

Re: 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.

Highlighted
Helper III
Helper III

Re: PowerBI with Azure Data Lake Store

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.

Highlighted
New Member

Re: PowerBI with Azure Data Lake Store

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.

 

Highlighted
Helper III
Helper III

Re: PowerBI with Azure Data Lake Store

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?

 

Highlighted
New Member

Re: PowerBI with Azure Data Lake Store

I published the report to PowerBI.com and I could refresh the data there. Don't need the gateway, there's no local to cloud data movement involved here. (Direct connection). I just needed to re-enter my credentials for the DataLake reference.

Highlighted
Regular Visitor

Re: PowerBI with Azure Data Lake Store

I am getting the followin error, while trying to re-enter the credentials

Failed to update data source credentials: The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.Hide details

Activity ID:    f3753c07-f1f2-4d8e-b55e-af0a9b0ec4e8
Request ID:    323a3391-1a49-6c15-3ed8-c0792e4c2610
Status code:    400
Time:    Wed Nov 16 2016 13:26:42 GMT+0100 (W. Europe Standard Time)
Version:    13.0.1700.581
Cluster URI:    https://wabi-north-europe-redirect.analysis.windows.net
Details:    The credentials provided for the DataLake source are invalid. (Source at https://xxx.azuredatalakestore.net/yyy.)

Highlighted
Frequent Visitor

Re: PowerBI with Azure Data Lake Store

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?

Highlighted
Regular Visitor

Re: PowerBI with Azure Data Lake Store

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors