Forum Discussion

viferenc's avatar
viferenc
Icon for Helper II rankHelper II
4 years ago
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...
Need Help
viferenc's avatar
viferenc
Icon for Helper II rankHelper II
4 years ago

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.

 

 

 

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Try in the SQL statement you write to change the type

  • viferenc's avatar
    viferenc
    Icon for Helper II rankHelper II
    4 years ago

    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