Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.