Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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!