Solved: Ensuring No Duplicate Values When Pulling From Fol...

Anonymous · ‎08-13-2019

Hello! I am currently building a report and have my data source set up so that records are appending to a table once a new file is added. My question is how this process works exactly? If I update a file, will the record in power query get updated or will a new record be appended and ultimately not be updated. For example, see the original and updated file examples below:

Original file

Updated File

Will my query refelct this update or will it just append a record that has product A sales of 22?

Thanks!

ImkeF · ‎08-13-2019

Hi @Anonymous

Power BI /Power Query by default will not keep any data from previous refreshes, but will always overwrite existing data with the results from the current refresh.

There are workarounds that you can find with "Power Query incremental refresh" in your favourite search engine, but unless your using a premium capacity they all have their drawbacks.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries