Forum Discussion

lynnzrae's avatar
lynnzrae
Helper I
2 years ago

Merged Rows Created by Group By Doesn't Update when Refreshing Data

I did a group by to merge/concatenate rows that used the same ID and everything  looked great (the top table).  I refreshed my data and had a new row that needed to be brought  into the existing merged row b/c it had the same ID (the second row in the second table below) and it didn't bring it in.  It now has a separate row.  

The 7332 is the key. this is what it currently looks like with the first row being the result of the inital grouping:

 

This is what it looked like when I first did the group by

IDP NumberStore NumberFile NumberNames of Product
7332632573921, 34749Teflon Foot, Compensating Foot
 
This is what it looked like when I refreshed the data and now have three rows that have the same ID; only the rows already merged were merged, the third row, when brought in what the refresh did not automatically merge.
IDP NumberStore NumberFile NumberNames of Product
7332632573921, 34749Teflon Foot, Compensating Foot
7332632573925Piping Foot

 

This is what it should look like based after today's data refresh:

 

IDP NumberStore NumberFile NumberNames of Product
7332632573921, 34749, 3925Teflon Foot, Compensating Foot, Piping Foot

 

Do I have to regroup every time I have a data refresh?

Need Help

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    2 years ago

    Are you doing 'Group by' on only the ID column? What's the datatype of that column?  It looks like powerbi thinks it is a different value (possibly you have text datatype on column and there are spaces)

    • lynnzrae's avatar
      lynnzrae
      Helper I
      2 years ago

      I think it was from another item that I didn't merge and the data was different so it separated the two rows out.  I'll keep an eye out if it does it again and report back.  Thank you for the suggestion!