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.

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors (Last Month)