Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Karltomm
Regular Visitor

API get changes and apply update dataset

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! 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User


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

2 REPLIES 2
Karltomm
Regular Visitor

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
Super User
Super User


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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.