Forum Discussion

markmacardle's avatar
markmacardle
Icon for Advocate I rankAdvocate I
6 years ago
Solved

Weirdly 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...
Need Help
  • markmacardle's avatar
    markmacardle
    6 years ago

    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.

saraMissBI's avatar
saraMissBI
Icon for Resolver I rankResolver I
6 years ago

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's avatar
    markmacardle
    Icon for Advocate I rankAdvocate I
    6 years ago

    See below. I've filtered the review_body column for starts with "Worst insurance services" and sorted it ascending

     

    • saraMissBI's avatar
      saraMissBI
      Icon for Resolver I rankResolver I
      6 years ago

      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,

      • markmacardle's avatar
        markmacardle
        Icon for Advocate I rankAdvocate I
        6 years ago

        saraMissBIthanks for having a look but I checked the source data and it's fine. Also as I mention in the original post if I filter the reviews in the Query Editor I'll only get one row that starts with "Worst insurance services". After importing though I see mutliple rows starting with "Worst insurance services" so it's an issue that must be happening in Power BI.