Skip to main content

    Power BI

    New

    EXASOL DirectQuery Connector

    Vote (38) Share
    Thomas Bestfleisch's profile image

    Thomas Bestfleisch on 24 Mar 2016 16:14:08

    Currently the EXASOL analytic database can be connected only via ODBC. It would be great to have a dedicated DirectQuery connector to fully exploit the power of an EXASOL cluster

    Comments (6)
    Thomas Bestfleisch's profile image Profile Picture

    56b1d10c 907a-e611-80ed-5065f38a4b71 on 05 Jul 2020 23:32:13

    RE: EXASOL DirectQuery Connector

    From October 2018 there is a certified Connector between Exasol and Power BI.

    Thomas Bestfleisch's profile image Profile Picture

    c8ecb622 662e-4253-90ba-287982432648 on 05 Jul 2020 22:55:46

    RE: EXASOL DirectQuery Connector

    pls add connector, waiting for it

    Thomas Bestfleisch's profile image Profile Picture

    95475f9e 2a52-4038-9626-9a173412dd4f on 05 Jul 2020 22:54:02

    RE: EXASOL DirectQuery Connector

    A connector for Exasol is now available, see https://github.com/EXASOL/powerbi-exasol

    Thomas Bestfleisch's profile image Profile Picture

    79416227 1f76-482f-89eb-a4d9f3ef6ce2 on 05 Jul 2020 22:28:58

    RE: EXASOL DirectQuery Connector

    A direct integration of Exasol into Power BI would be very helpful!

    Thomas Bestfleisch's profile image Profile Picture

    b449f788 6482-4a83-b0bd-5e8af497eb92 on 05 Jul 2020 22:27:10

    RE: EXASOL DirectQuery Connector

    As an alternative, use SSAS (analytic services) and setup a real-time ROLAP against EXASOL. Then connect Power BI to EXASOL via the SSAS ROLAP. Long term, a native connector would be ideal.

    Thomas Bestfleisch's profile image Profile Picture

    280d74c8 b728-4c4f-96c1-187ecb1480ad on 05 Jul 2020 22:19:57

    RE: EXASOL DirectQuery Connector

    ODBC works terribly slow with Exasol. Need to have a proper connector.