Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
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?
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!