Old line item added on top of new line item in data source

[CelineFoong]

Hi Power BI Community

I am creating a new query using data from 1 excel file . Lets take the data excel file name as "ABC.xlsx"

The total number of lines under "ABC.xlsx" is 785 lines . After inducting this "ABC.xlsx" data source, i went ahead to transform and apply the necessary formulas to generated the expected output 

Afterwhich , i tried to replace the "ABC.xlsx" by deleting the 785 lines first and then copy and paste with another set of fresh data "DEF" which consist of 4889 lines .

The expected output lines became (4889+785)=5,674 lines instead of 4889 lines after multiple refresh clicks. The expected output lines seems to be adding "ABC+DEF" lines instead of just "DEF" lines.

Appreciate if you can assist

[v-eqin-msft]

Hi @CelineFoong ,

Glad to know your issue has been solved. Please kindly Accept it as the solution to make the thread closed. More people will benefit from it. 

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @CelineFoong ,

Any updates?

Best Regards,
Eyelyn Qin

[CelineFoong · Accepted solution]

Hi Evelyn 

Thanks for your response. i tried the below method but it doesnt work.Instead i re-do the whole report and it works now. 

Thanks for your help and reply

Celine

[v-eqin-msft]

Hi @CelineFoong ,

It's weird. I could not reproduce your issue.

How did you do this step : i tried to replace the "ABC.xlsx" by deleting the 785 lines first and then copy and paste with another set 

Please directly change data source and have a try again.

Or if you are still confused about it, please provide me with more details like the whole M syntax... ( and please hide sensitive data)

Best Regards,
Eyelyn Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.