Forum Discussion
Problem with tables in Power Query Editor due to ODBC
Hi, DM0010 ;
Try to configure both user DSN and System DSN for this connection in the ODBC data source, and create DSN and test in both 32-bit/64-bit ODBC data source.
Solved: ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manage... - Microsoft Power BI Community
In additional,
A 32-bit driver cannot work with a 64-bit App.
In your specific case you'd better change the MySQl ODBC Driver version from 32-bit to 64-bit.
Hence PBI, ODBC Oracle and ODBC MySQL will be in 64-bit versions
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, DM0010 ;
Try to configure both user DSN and System DSN for this connection in the ODBC data source, and create DSN and test in both 32-bit/64-bit ODBC data source.
Solved: ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manage... - Microsoft Power BI Community
In additional,
A 32-bit driver cannot work with a 64-bit App.
In your specific case you'd better change the MySQl ODBC Driver version from 32-bit to 64-bit.
Hence PBI, ODBC Oracle and ODBC MySQL will be in 64-bit versions
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.