Forum Discussion
cell lengh
I have a big data base in which there is a column with a long text in each cell. In excel I can read it completely but when I import the base into Power BI it truncates this column and doesn't show the entire text. How can I solve it?
Thanks!
9 Replies
- amitchandak
Super User
Anonymous , Open Edit Query/Data transformation mode and right-click on table and open advance editor. dataType should int64 or number. If not change it and try .
Keep backup of file
- Icey
Community Support
Hi Anonymous ,
Please check whether the length of the string exceeds the maximum limit.
Text type
Text - A Unicode character data string. Can be strings, numbers, or dates represented in a text format. Maximum string length is 268,435,456 Unicode characters (256 mega characters) or 536,870,912 bytes.
Reference: Data types in Power BI Desktop
Best regards
Icey
If this post helps,then consider Accepting it as the solution to help other members find it faster.
- Icey
Hi Anonymous ,
Could you share us some screenshots of the issue? Please cover sensitive information.
Best regards
Icey
amikmHelper V
HI Anonymous ,
It looks like you are taking data from some SQL data source and column length in the source table is defined as Varchar(255). Could you Please change the length of that column in the source to varchar(max) then import or Do a direct query and see the results?
Amit
- Icey
Hi Anonymous ,
I find one situation, is it the same as the situation you encountered?
This is by design. You can check the entire text in visuals, like Table visual.
Best regards
Icey
If this post helps,then consider Accepting it as the solution to help other members find it faster.
