Skip to main content

    Power BI

    Under Review

    ODBC Data Sources in Dataflows

    Vote (75) Share
    Eric's profile image

    Eric on 22 Nov 2018 20:52:45

    Please add ODBC data source connectors for Dataflows. Many of our queries connect through ODBC drivers because direct access to the DB2 database is not allowed through the DB2 driver.

    Comments (3)
    Eric's profile image Profile Picture

    4808d294 cd0d-4577-8f1a-a2ff2c3f51f3 on 05 Jul 2020 23:37:51

    RE: ODBC Data Sources in Dataflows

    Until we add support for ODBC connector UX, what you can do is to use Power BI Desktop to create the connection, then copy the M script to a blank query in Power BI dataflows.
    See this blog post for the 'How to' -
    https://ssbipolar.com/2018/12/06/authoring-power-bi-dataflows-in-power-bi-desktop/

    Let us know if you find it useful.

    Eric's profile image Profile Picture

    373a2053 b853-49d1-8046-bd6c78f055f1 on 05 Jul 2020 23:36:52

    RE: ODBC Data Sources in Dataflows

    Hope to see this. Hope they can at least give us an indication if this might happen some day.

    Eric's profile image Profile Picture

    42809460 2fff-44f7-aba6-9348e449ef19 on 05 Jul 2020 23:36:26

    RE: ODBC Data Sources in Dataflows

    Yes please, this is a must !!!