How can we improve Microsoft Azure Data Lake?

Output to PowerBI

Output to PowerBI

140 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    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.

    13 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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