Character length

[aduncan]

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?

[amitchandak]

@aduncan , refer if this can help

https://blog.crossjoin.co.uk/2019/05/17/maximum-length-text-value-power-bi/

[AllisonKennedy]

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? 

[parry2k]

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

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.

[v-deddai1-msft]

Hi @aduncan ,

Are you trying to load a large number of data into Power BI? Did you get the warning: The data in the preview has been truncated due to size limits?

Please refer to https://community.powerbi.com/t5/Desktop/The-data-in-the-preview-has-been-truncated-due-to-size-limi...

Best Regards,

Dedmon Dai

[aduncan]

Thanks for helping @v-deddai1-msft 

Data table is small, less than 5000 rows, no warnings

[parry2k]

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

Thanks for helping @parry2k 

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

[parry2k]

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