Skip to main content

    Power BI

    Needs Votes

    Direct Query conenction with Hive

    Vote (28) Share
    's profile image

    on 16 Mar 2018 11:54:03

    In the latest version of Power BI, Direct Query connection with Hive is not possible. We can use ODBC for Hive and only import connection is availble with ODBC.
    So, it will be great if we get Direct Query(Live) connection for Hive.

    Comments (3)
    's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:06:38

    RE: Direct Query conenction with Hive

    Hello,
    Are there any news regarding support of Regular Hive with an usable Direct Query experience? Or is there a workaround?

    's profile image Profile Picture

    Tan on 05 Jul 2020 23:17:46

    RE: Direct Query conenction with Hive

    '@Matt, any idea if this Interactive Query connector is/would be available for an on-premise Power BI Report server set up?

    's profile image Profile Picture

    Matt Masson on 05 Jul 2020 23:17:01

    RE: Direct Query conenction with Hive

    Power BI supports Hive LLAP through the HDInsight Interactive Query connector.

    https://docs.microsoft.com/en-us/azure/hdinsight/interactive-query/apache-hadoop-connect-hive-power-bi-directquery

    Regular Hive (i.e. non-LLAP) is non-interactive, and does not provide a usable Direct Query experience.