Forum Discussion
Merge Queries as New_Duplicated Rows after Refresh
Dear all,
I´m facing an issue when a "Merge Queries as New" option creates duplicated rows after refreshing a data source that is stored on SharePoint site.
Original Query doesn´t have this issue, but the one I created based on the original one creates duplicated rows.
Any idea why?
Thank you in advance!
BR,
Matej
What Join Kind you have used?
Available Join Kind:
- Left Outer
- Right Outer
- Full Outer
- Inner
- Left Anti
- Right Anti
For more details - https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9
HI Matej_SVK,
Can you please share some more detailed information about these operations to help us clarify your scenario? It is hard to troubleshoot without any detailed information.
How to Get Your Question Answered Quickly
Regards,Xiaoxin Sheng
3 Replies
What Join Kind you have used?
Available Join Kind:
- Left Outer
- Right Outer
- Full Outer
- Inner
- Left Anti
- Right Anti
For more details - https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616d17f9
HI Matej_SVK,
Can you please share some more detailed information about these operations to help us clarify your scenario? It is hard to troubleshoot without any detailed information.
How to Get Your Question Answered Quickly
Regards,Xiaoxin Sheng
Dear all, problem has been solved. The issue was that the second source file had more results for the same item in original query - this was creating duplicates after refresh. Thank you for your suggestions. 🙂
