Forum Discussion
Problem with tables in Power Query Editor due to ODBC
Hi all!
I have a problem with my ODBC loaded tables on Power BI. I can't use the Power Query Editor on these tables, because there is some kind of error:
Does this error specifically occur with ODBC or is there a way to resolve this?
Maybe worth to mention that the ODBC was not set up by me and is being administered by a third party.
Thanks in advance for helping me out!
DM0010
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.
1 Reply
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.