Forum Discussion
Data appears twice in power query
Verify your data source doesn't have duplicated data. If the source is Excel delete all the rows in the workbook after the last know row.
If that doesn't fix it post your m code. Also if it's duplicating the data, select all columns and click Remive Duplicates....however that's a poor band aid as you really want to find the root cause of the duplicates.
Thank you for your suggestion.
The problem was from the data source so I corrected it from there and added index column.
Hi bammyd36 ,
1. 1. If each row is unique, consider using Table.Distinct ()
2. Consider adding an index column in your data source.
If that still doesn't solve the problem, consider publishing the code in the advanced editor, taking care to remove the data source information, we need to know how it is queried.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thank you for your suggestion.
The problem was from the data source so I corrected it from there and added index column.