I am finding duplicate values in my dataset after I try to refresh. There are no duplicate values showing when I run my query independently or in Power Query before I load to PowerBI. Has anyone seen this happen before and know of any resolution?
Turns out I was creating columns in my dataset in PowerBI that I should have been creating in Power Query. Making these changes, removed this duplicate situation. It was very odd. I'm a pretty new user so I'm still working through all the kinks 🙂
@aleggore Extremely vague. Power Query only loads the first 1000 rows as preview. Are you appending some query to an existing table? Also, Power Query and DAX have different rules for what they consider duplicates. For example, DAX doesn't care about case while Power Query does. So, need more to go on in terms of what is going on.