Dataflow Silently Truncating Text to 1023 Characters

[michaeltclark4]

Hi, 

As the title suggests, I have a problem with my dataflow truncating the text in a cell to 1023 characters. The non-truncated text length when the datasource is loaded in Power BI Desktop is ~1,800 characters. 

The column is a text type. 

The query is folding to the datasource. The datasource is a SQLite .db file read by an ODBC driver via a gateway. I can't find any indication as to why this truncation is happening. 

[lbendlin]

Experiment with the column type. keep it at "Any" or change it to binary. Then check the size of the blob.