Forum Discussion

vincent_1234's avatar
vincent_1234
Helper I
10 years ago

Maximum text length

Dear developers,   I've imported data from a plain sql server table. One column contains many characters, however according the documentation this should not be an issue. https://powerbi.microsoft...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

I wonder if this is a limitation of Power Query "M" versus the Desktop data model types. In other words, the data model Text type can theoretically support large amounts of text but the import process using Power Query is truncating it to 32,766 characters.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  Greg_Deckler ,

I think I am experiencing the scenario that you have just described. Power Query appears to truncate to 32K characters.

 

Is there a solution for this?

 

Thanks