Forum Discussion
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 merg...
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)
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!
