Forum Discussion

viferenc's avatar
viferenc
Helper 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
Helper II
4 years ago

Thank you, it works.

 

but now I have received another error message

 

 

 

Thank you for your support

 

BR

 

Feri

 

SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

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.

  • viferenc's avatar
    viferenc
    Helper 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
      Community Champion
      4 years ago

      Try in the SQL statement you write to change the type

      • viferenc's avatar
        viferenc
        Helper 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