Forum Discussion
Remove duplicate rows when refreshing
Hi, Anonymous
Based on your description, I'd like to suggest you refer to Referencing Power Query queries about reference. You may parameterise a data source to load the entire folder. For further information, please refer to the following links.
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sounds like you are using some sort of Append query or perhaps a Folder query. Can you create another query, reference your Append or Folder query and add your remove duplicate rows there?
yes I loaded a folder and have to append to combine multiple worksheets of each workbook. taking all the data to a new query/table will resolve this issue? Sorry i'm new in this. There's no way to remove it directly in the created table?
These are the steps applied in the sample file