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?
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:
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.
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)
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.)
Check out the on demand sessions that are available now!
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021
Mark your calendars and join us for our next Power BI Dev Camp!.