Forum Discussion
viferenc
Helper II
4 years agoODBC - You have an error in your SQL syntax
Dear All, I would like to ask for your advice. I would like to connect data to Power BI Desktop through ODBC. As you can see the ODBC Connection is working. I have also copied the field typ...
- 4 years ago
Try looking here:
https://www.w3schools.com/sql/func_mysql_convert.asp
SpartaBI
Community Champion
4 years agoTry in the SQL statement you write to change the type
viferenc
Helper II
4 years agoI´m sorry, is there a possibility to help me by writting the SQL statment. Unfortunately I´m not so developed in SQL statement, I can do the simply ones but this does not work for me.
Thank you in advance
BR
Feri
- SpartaBI4 years ago
Community Champion
Try looking here:
https://www.w3schools.com/sql/func_mysql_convert.asp