Forum Discussion

aduncan's avatar
aduncan
Frequent Visitor
6 years ago

Character length

My database has an input field that holds well over 100 characters, however when I query a table that data column get only the first 8 characters. Is there a way to specify the amount of characters ...
Need Help
aduncan's avatar
aduncan
Frequent Visitor
6 years ago

Data is pulling using ODBC from a database. The frontend of the database provides a paragraph field for data entry. Yes the full paragraph of text is visiable with the database table, however once the table is loading into Power BI only 8 characters are available.

parry2k's avatar
parry2k
Super User
6 years ago

aduncan did you used any other tool except Power BI to connect using ODBC and see what kind of result you are getting.  It is not clear if that ODBC driver is not giving the full data or Power BI is translating it something different, so testing with other tools can provide some insight.

  • aduncan's avatar
    aduncan
    Frequent Visitor
    6 years ago

    Thanks for helping parry2k 

     

    Interesting; Can you recommend any other applications/tools for testing?

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      aduncan sorry man, its been a while I used ODBC, I'm sure tons of free tools, I found this one, please read and go thru it carefully before using it as I'm no expert on these. https://www.gpoulose.com/