Skip to main content
Microsoft Idea

    Power BI

    Completed

    ODBC Data Sources in Dataflows

    Vote (77) 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.

    Administrator on 14 Oct 2021 21:36:45

    Dataflows support ODBC sources, to learn more: https://docs.microsoft.com/en-us/power-query/connectors/odbc

    Comments (3)
    Eric's profile image Profile Picture

    Yaron Canari 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

    Jonathan 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

    Dimitar D on 05 Jul 2020 23:36:26

    RE: ODBC Data Sources in Dataflows

    Yes please, this is a must !!!