Problem with tables in Power Query Editor due to ODBC

[DM0010]

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

[v-yalanwu-msft · Accepted solution]

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

error [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified wh...

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.