Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]
Solved! Go to 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.
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.