March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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!
Solved! Go to Solution.
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.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
7 | |
3 | |
2 | |
1 | |
1 |
User | Count |
---|---|
8 | |
3 | |
2 | |
2 | |
2 |