Forum Discussion
Solved
ODBC - 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...
Try looking here:
https://www.w3schools.com/sql/func_mysql_convert.asp
I have found the columns.
I have the problem with columns where the type varchar is.
Is there a possibilty to change the type during the loading. If yes, how.
In the database I´m not able to change anything, I have only reading rights.
Thank you for your help.
Try in the SQL statement you write to change the type
I´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
Try looking here:
https://www.w3schools.com/sql/func_mysql_convert.asp