Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 t...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the answer but the data that is being truncated is actually a text, so I can't change into number type. Any other ideas?