Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Experiment with the column type. keep it at "Any" or change it to binary. Then check the size of the blob.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.