Forum Discussion
ODBC - You have an error in your SQL syntax
Try looking here:
https://www.w3schools.com/sql/func_mysql_convert.asp
viferenc
Remove the first row from the code.
Refer to the database in the connection string box above.
Alternatively, you can put it in the ODBC configuration dialog box to set some stuff there as default, like server, database etc.
What ever you will put in the conneciton string in the Power BI will override the default in case they collide.
Hope that helps.
Thank you, it works.
but now I have received another error message
Thank you for your support
BR
Feri
From the error message I can suspect that maybe one of your columns in the source has a data type not supported by Power BI. Try check that by elimination, only bring one at a time and see which one cause that error.
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