Forum Discussion
Solved
After refreshing data is doubling
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 ...
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.
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!