Forum Discussion
Weirdly repeating text values in a table
I eventually figured out it is caused by the length of text strings being >=512 characters long.
The column limited to 511 characters shows the correct text, but when the limit is 512 characters any values that hit this limit start getting duplicated and overwriting other rows in the column. The amount of other rows, and which ones, that get overwritten seems to be pretty random.
I was initially using version 2.71 (July 2019) and have updated to the latest version, 2.75.5649.961 64-bit (November 2019). The bug is present in both.
I eventually figured out it is caused by the length of text strings being >=512 characters long.
The column limited to 511 characters shows the correct text, but when the limit is 512 characters any values that hit this limit start getting duplicated and overwriting other rows in the column. The amount of other rows, and which ones, that get overwritten seems to be pretty random.
I was initially using version 2.71 (July 2019) and have updated to the latest version, 2.75.5649.961 64-bit (November 2019). The bug is present in both.
I've raised this as an idea to try get this bug fixed here https://community.powerbi.com/t5/Issues/Bug-when-text-string-gt-512-characters/idi-p/875358#M51863