Forum Discussion
Refresh updated records without full refresh
Hello, folks
I started playing with Power BI a few days ago, fetching data from our provider of maintenance system with REST/JSON. I was able to get all records (~5k maintenance work orders, what required about 30 minutes to load) using the server's pagination procedure (500 records per page).
Now, I wanted to refresh changed orders, without the need to refresh the full data, to speed up the process. The server is able to deliver me only changed orders, but I could not find how to set up the query this way.
For the pagination I was able to merge the results into one table, but how could I set up the update to the same table?
Thanks, and regards,
Mauricio
You may check if the post below helps.
https://community.powerbi.com/t5/Developer/Updating-Data-with-Push-Push-Data-Sets/m-p/898558#M21982
8 Replies
- Apparently what I'm looking for is not possible...
https://community.powerbi.com/t5/Desktop/Avoid-refreshing-from-database/m-p/809326
https://community.powerbi.com/t5/Power-Query/Query-dependencies-avoid-full-refresh/m-p/978814
Please leave a note if you found a different conclusion.
Thanks
You may check if the post below helps.
https://community.powerbi.com/t5/Developer/Updating-Data-with-Push-Push-Data-Sets/m-p/898558#M21982
Looks promissing, let me read about it a little bit more, but that could be the answer!
Regards
Hi,
check if this can help. You'll find this dialog right clicking a table in model view .
Regards FrankAT
- Hi,
From what I read, there should be support from the server for this operation and, besides, you set up a date interval for refresh.
What I would expect to have is what you can do with any database system, that is an update query.
Regards
- Well,
The post is on Power BI Desktop, and your reply applies to Excel.
Besides, I asked how to NOT refresh everything, and your method would refresh all the datasources.
I don't know if you really thought that would help, or you're just looking to increase your statistics.
