Forum Discussion
aduncan
6 years agoFrequent Visitor
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 ...
aduncan
6 years agoFrequent Visitor
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
6 years agoCommunity Support
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-limits/td-p/34191
Best Regards,
Dedmon Dai
- aduncan6 years agoFrequent Visitor