Group By not continuously applying

[KylePalardy]

I am writing a program to track the timesheet entries on projects to a dashboard that I have created in Power Bi. I have the databases set up on a many to one relationship, and the one has a group by in the 'applied steps'. The scheduled refresh failed after publishing the new relationship with a message saying the grouped column contains a duplcate value. I thought the group by function would continuously update when new data was put into the system. Some assistance with this would be helpful.

[jgeddes]

Relationship refresh failures are often caused by blank values in the one side of the relationship. You can check your grouping step for the presence of null values. These will pull through as blanks and cause the relationship error.

[KylePalardy]

I did some digging for null values and did not find anything. I did notice there is a duplicate value and although I manually refreshed the data, it is still causing an error and not grouping the data as it did with the other projects.

[jgeddes · Accepted solution]

What I would be looking for next is to verify that the duplicate values are the exact same. Things like trailing spaces, differing cases etc. are all treated as unique entries. Example "group item " and "group item" would show as two separate rows when grouping.

[KylePalardy]

I double checked and they are the same. I am getting an error message with the exact name that says it cannot run the many to one relationship because they are duplicates. 

The message reads: Column 'SUMMARY' in Table 'X' contains a duplicate value. This is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

[jgeddes]

Can you share a screenshot of the column values? 

[KylePalardy]

This is totally my mistake. There is an extra space, but since I am not able to change the text directly in the transform data tab, I skipped right over it. Thank you for the patience and assistance.