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
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.
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.
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
