Solved: API get changes and apply update dataset

Karltomm · ‎12-01-2023

Hi!

I am connecting to a API and the API have two GET functions I can use, Get all and Get changes.

I have made a Query1 where I get all rows and I have a Query2 that get changes the last 24h. Both queries works and I get lists with rows of data. My plan is to update the dataset one time per day with the schedule refresh.

My question is how do I implement the rows with changes retrived in Query2 in the dataset of Query 1?

The changes can be a new row or a row with changes in some columns but all data is in the row so it should replace the previous row with the same ID.

Best Regards!

lbendlin · ‎12-02-2023

Power BI has no memory* . You need to manage your snapshots in the upstream system. * Yes, there is the self referencing option but that has no safety net.

View solution in original post

Karltomm · ‎12-03-2023

Thanks for the answer!

Then I will test to copy the data into Dataverse table and work from there and maybe I need to use PowerAutomate to update the table.

lbendlin · ‎12-02-2023

Power BI has no memory* . You need to manage your snapshots in the upstream system. * Yes, there is the self referencing option but that has no safety net.