ODBC Data Sources in Dataflows

[eglover]

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.

[jonathan19]

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

[ddraganov]

Yes please, this is a must !!!

[yaronc]

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.

[nishalit]

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