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 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
Solved! Go to 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
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
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
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.