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

[lynnzrae]

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

ID	P Number	Store Number	File Number	Names of Product
7332	6325	7	3921, 34749	Teflon 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.

ID	P Number	Store Number	File Number	Names of Product
7332	6325	7	3921, 34749	Teflon Foot, Compensating Foot
7332	6325	7	3925	Piping Foot

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

ID	P Number	Store Number	File Number	Names of Product
7332	6325	7	3921, 34749, 3925	Teflon Foot, Compensating Foot, Piping Foot

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

[HotChilli]

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]

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!