ado truncates return value Power query does not

Hi
Querying a denodo table in excel. With power query, 1 particular field comes back >255 length. When I use adodb vba, the field gets truncated to 255?? Any ideas??

My code:

Please Login or Register  to view this content.

SOLVED!!!!
sql cast: select cast(business_justification_note as char(5000))....