Power Query Duplicating rows(twice/trice)

[hasharma19]

Hi All,

I have a excel file, haveing multiple sheets(Jan, Feb..ect) with some tasks assigned to team.

If specific person completed the task i am caturing Done aganist the task and X for imcomplete/not attempted task.

No dates is available in data.

No while uploading the file into Power BI Desktop, a single record showing twice/thrice. However, no duplicate entry available in source file. In soruce file, tasks are same in every months & people will be also same but with different task assigned.

Need your help to know the reason.

below are the SS of source file & PBI

Signle record shwoing twice

[Ritaf1983 · Accepted solution]

Hi @hasharma19 
It seems that there are merged tables cause the duplicating.
You can concatenate the name with the month and remove duplicates from PQ.

Result :

The pbix is attached

*The merged step can be removed, the steps of PQ will repeat themselves every refresh

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.