ODBC Data Source Error

[alex_liew]

I was previously able to get data using ODBC driver but am unable now mon Power BI Desktop.

I know nothing has changed or updated on the server recently.  And I know it works as the published report managed to refresh via personal gateway.

What's the best way to resovle this issue?

Error Message:

DataSource.Error: ODBC: ERROR [S1090] [Schneider Electric][ClearSCADA database driver]Unexpected keyword
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=PHOSCDA02
OdbcErrors=[Table]

[dax · Accepted solution]

Hi @alex_liew , 

It seems to be related to ODBC version, what is version of ODBC you used currently(32bit or 64bit)? In addition, you also could try to update the ODBC to see whether it work or not. You could refer to gettin-error-while-connecting-to-database-using-odbc  and ODBC-behavior-error  for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.