eglover's avatar
eglover
New Member
7 years ago
Status:
Completed

ODBC Data Sources in Dataflows

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.
Data Factory | Connectors
power bi
yaronc's avatar
yaronc
Icon for Power BI Team rankPower BI Team
6 years ago
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.

Recent ideas