Output to PowerBI
Output to PowerBI
Andy Cross
shared this idea
Something we have on the roadmap.
20 comments
-
Paul David Lassiter
commented
The Qubole Presto offering with PowerBI supports all the frequently used data types on the Azure Data Lake including Apache ORC, Parquet, avro, csv, etc. Apache Presto is an open source ANSI compliant SQL in memory engine that allows PowerBI users with SQL skills to write queries to pull data into a Presto notebook and/or PowerBI. Qubole offers presto as a service on Azure with workload aware autoscaling which is serverless minimizing your compute costs on the Azure Data Lake for Azure Data Lake analytics.
-
Paul David Lassiter
commented
The Qubole connector works with PowerBI, Tableau, Looker and other BI tools.
-
Paul David Lassiter
commented
Qubole a Microsoft ISV partner has a published PowerBI connector that allows you to do direct and federated queries with PowerBI on the Azure Data Lake and other data sources. Qubole offers a free hands on workshop onsite with PowerBI users to enable this access and is very affordable tool to add to your Azure analytics tool kit. You can learn more about the PowerBI connector at this blog: https://www.qubole.com/blog/qubole-brings-federated-queries-to-microsoft-power-bi-with-presto/ and here is the Qubole documentation on the feature: https://docs.qubole.com/en/latest/partner-integration/powerbi-integration/powerbi-setup-connector.html. Also, the hands on workshop is valued at $20,000 since Qubole provides free architect support to deploy Qubole in your Azure subscription to prepare for the workshop and a free two week pilot with architect support for your PowerBI analysts. Contact Dave Lassiter at dlassiter@qubole.com if you are interested in the free workshop/pilot offer.
-
Pat
commented
Azure website mentions that ADLA compares to AWS Athena.
However it is possible to connect AWS Athena to a visualisation tool like Tableau. I don't understand why ADLA does not provide such capacities for Power BI. -
Dmitriy
commented
I' really don't understand why this feature didn't do in ADLA?
-
Anonymous
commented
This is an important future Microsoft is missing.
I was shocked to find out it doesn't support this.
I hope they do fix this. -
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.