After refreshing data is doubling

[LevanZukhbaia]

Hi everyone,

I have PBIX file which is connected "Dynamics 365 Business Central", I needed 2 query to Append, but befor I mede chanegs in this 2 query (I merged, removed and renamed columns) it was working properly and yestrday I dicovered that some informaiton dubled.
I heve row file and in that file there is no this error.
can anyone help me?

[LevanZukhbaia · Accepted solution]

I discovered problem myself and It was this: The Query to which I merged have 3 or 4 Duplicate record, so I copied this Query, remove duplicate values and then merged this two Queries, this soled the problem.

[v-kelly-msft]

Hi @LevanZukhbaia ，

You mean that when you did "merge,remove and rename"steps,you didnt find any error,but when you add 2 queries to append,your data is doubled,right?If so,would you pls paste your queries here for check?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!