Output to PowerBI
Output to PowerBI
Andy Cross
shared this idea
Something we have on the roadmap.
14 comments
-
William Blakey
commented
We are beginning to dive into integrating PowerBI models with our applications, as well. We're using ADLA heavily, leveraging "databases" along with stored procedures, views, functions, etc. ADLA seems very isolated still, like others would be able to make great use of querying ADLA objects/files from outside of ADLA.
-
Anonymous
commented
So important and yet more than 2 years ago "Planned".
-
Anonymous
commented
As this has been planned since 2015, any updates on when we might see Power BI be able to access ADLA?
-
Chris Bailiss
commented
More connectivity options are badly needed into Azure Data Lake Analytics. A Power BI connector that supports query folding is essential. It's disappointing that this was marked as "planned" more than two years ago and has yet to appear. Microsoft are being leapfrogged by AWS at the moment as AWS Athena is now appearing as a more mature option (supports ORC/Parquet, has ODBC and JDBC connectivity), etc.
-
Sam Chen
commented
Please retain the column header and data type when outputting to PowerBI (and Excel PowerQuery). Otherwise, this is no better than converting to delimited text in blob store, which can already be read in by PowerBI (but is very cumbersome because you have to redeclare all of the column headers and account for special characters like commas and tab)
-
Jasmeet Singh
commented
Please support submitting ADLA queries from BI tools like SSRS and Power BI Direct Query.
-
Nirnay
commented
It would be great if power bi could query an Azure Data Lake file/table directly.
-
Alex Kyllo
commented
This is the killer feature that would drive adoption for ADLA / U-SQL Databases. Currently you can't query them with anything but a U-SQL job, so the use cases are super limited. If you built an interface to query them interactively, connect to them from Excel (Power Query) and Power BI, or perhaps even just an ODBC driver (like HiveODBC), my team would start using them for practically everything.
-
Raphael Nash
commented
It would be great if power bi could query an Azure Data Lake file/table directly.
-
Half Scheidl
commented
Hello Guy, and thanks Andrew for sharing your thoughts. I had a similar question. Since you cannot connect to Azure Data Lake Analytics tables and views from Power BI desktop, I currently see no difference whatsoever in using e.g. Azure Blob Storage, since in Power BI both show up as binaries. Is this a question applicable to Power BI product team?
-
Helge Rege Gårdsvoll
commented
Excel should be able to read data in Azure Data Lake Store through Poewr Query or other connectivity.
-
Andrew Davis
commented
Not sure if this is possible today, but from Excel you can't connect to any of the Azure Data Lake technologies.
From Power BI, you can only connect to Azure Data Lake Storage, not Azure Data Lake Analytics - Tables and Views.
-
Ziv Shtaeinberg
commented
Can we receive some information on what will the new capabilities?
Example:
1. Will we have Hot Line & Cold Line?
2. Service Functionality result. -
Jörg Hubacher
commented
We are currently spending a lot of resources to use the power of Azure Data Lake. We really like to see aggregated data within PowerBI. Give us a hint, please, when we can expect a beta.