Forum Discussion
Advocate IWeirdly repeating text values in a table
I've connected to a table of reviews left by customers in BigQuery. When I make a table from this I see some of the values getting weirdly repeated. Below is an example of one of these values getting repeated.
The created_datetime_review, id and rating are all correct for the row, it's just the review that's wrong. The aggregation on all fields is set to "Don't summarize".
I've made this in a fresh report so the reviews data is the only table imported and there's no transformations or formula applied at all in DAX or the Query Editor. If I filter the review column in the Query Editor for begins with "Worst insurance services" I get only one row (which is correct). So I can't understand what's changing between then and this 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.
6 Replies
markmacardleI 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.
- markmacardle
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
- saraMissBI
Resolver I
Hi markmacardle ,
Could you please share a snapshot of your table from the Data section? ...to see how your data looks there.
Thank you,
- markmacardle
See below. I've filtered the review_body column for starts with "Worst insurance services" and sorted it ascending
- saraMissBI
Hi markmacardle ,
From what I see on your data table, then the table in your report is showing correct data. The data you imported to power bi has that review in several rows, and there is nothing wrong with the report.
Best regards,