How can we improve Microsoft Azure Data Lake?

Output to PowerBI

Output to PowerBI

156 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Andy Cross shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
planned  ·  Saveen responded  · 

Something we have on the roadmap.

20 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Paul David Lassiter commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    As this has been planned since 2015, any updates on when we might see Power BI be able to access ADLA?

  • Chris Bailiss commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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)

  • Nirnay commented  ·   ·  Flag as inappropriate

    It would be great if power bi could query an Azure Data Lake file/table directly.

  • Alex Kyllo commented  ·   ·  Flag as inappropriate

    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.

  • Half Scheidl commented  ·   ·  Flag as inappropriate

    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?

  • Andrew Davis commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base