Power Platform Community Forum Thread Details

Completely new to power query so forgive my ignorance.

I'm trying to get a table to update every 24 hours without duplicating entries.

The table has a unique field which should only appear once, followed by several columns of associated data.

I've managed to get a power query to populate the table initially, but on refresh it just seems to add the same data again.

I would like it to add new rows where the unique field does not exist, and where the field DOES exist, update that specific row to the newly refreshed data (not bothered if it's changed or not, just overwrite whatever the current values are)

can anyone help me with this?

Categories:

Power Query