Merge Queries as New_Duplicated Rows after Refresh

[Matej_SVK]

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

[SivaMani · Accepted solution]

@Matej_SVK, 

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-7ca2616...

[Matej_SVK]

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. 🙂

[v-shex-msft · Accepted solution]

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

[SivaMani · Accepted solution]

@Matej_SVK, 

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-7ca2616...