What are you trying to achieve?
Import data to a PowerBI Dashboard, but delete older entries in the model bases on one value.
Once a day I want to import data from an erp system into powerbi.
One of the values i use as an identifier is the “erpId”.
Every erpId should exist only once in my PowerBI model.
Is there a way throught make.com to guarantee this?
Steps taken so far
Haven’t tried anything perticular by now. I’m wondering if this is possible at all as i don’t see a finished model that would do the job.
Screenshots: scenario setup, module configuration, errors
So essentially you want to replace an old value with a new value correct?
If so all you need to do is use a search module to find the id and delete it before adding the new values.
Hope this helps!
Good morning @FPM_Support;
Conceptually, you can query your current erpID entries to create a simple array of them.
Then as you iterate through the incoming entries, check whether the entry’s erpID is {{contains}}(erpID-array; erpID) in router’s first branch filter to remove that entry, and then the router’s second branch adds the updated entry.
Good luck 
