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.
5 Comments
- Hope to see this. Hope they can at least give us an indication if this might happen some day.
- Yes please, this is a must !!!
yaroncPower BI Team
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.Dataflows support ODBC sources, to learn more: https://docs.microsoft.com/en-us/power-query/connectors/odbc
- Status added:Completed
