Forum Discussion
Group By not continuously applying
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.
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.
6 Replies
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.
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.
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.
