Forum Discussion
Incremental refresh and duplicate records
Hello everybody, I've recently started exploring the possibilities of the incremental refresh features to see if I can apply it to my reports. The situation is as follows: My data source is a...
GilbertQ
Super User
Super UserHi Klaasvh
What happens if you had to also use the column Detect Data Changes and configure that for the changes in data so that it will be re-processed?
I don't think I can. I only have the 'changed' column to work with, which either tells me when the record was created or last updated.
Somehow I doubt I can avoid having these duplicate records in my dataset. What I need is the most recent row for each 'ID' colum, perhaps I can do something in my M query to realise this?