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
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