topic Re: API get changes and apply update dataset in Developer

API get changes and apply update dataset

Karltomm — Fri, 01 Dec 2023 09:49:58 GMT

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!

Re: API get changes and apply update dataset

lbendlin — Sun, 03 Dec 2023 01:59:23 GMT

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.

Re: API get changes and apply update dataset

Karltomm — Mon, 04 Dec 2023 07:11:39 GMT

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.