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 to query for that specific column; lets say 250 instead the default 8?

 

Need Help

9 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    aduncan what is your data soure? I never see that query pulls only a few characters?  Are you pulling directly from table or view? Any other way you can check that column contains value more than 8 characters?

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

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    6 years ago

    What data source are you using for the database, what is the data type, which column is causing issues? 

    https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types

     

    You should be well within the character limitations, but depends on how the data is formatted a bit (I've encountered issues before with HTML for example). 

     

    Can you paste the M code from your Advanced Editor as a starting point so we can get a better idea for what's happening?