Forum Discussion

LevanZukhbaia's avatar
LevanZukhbaia
Frequent Visitor
5 years ago
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 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?

Need Help
  • LevanZukhbaia's avatar
    LevanZukhbaia
    5 years ago

    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.

2 Replies

  • LevanZukhbaia's avatar
    LevanZukhbaia
    Frequent Visitor
    5 years ago

    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's avatar
    v-kelly-msft
    Community Support
    5 years ago

    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!