By using this website, you agree to our Terms of Use (click here)
Refreshing data over OData is great, but sometimes the datasets can get pretty big. So there might be the need to only refresh updated records.
For more on that, checkout this post about only refreshing updated records with OData:
https://asiablog.acumatica.com/2019/05/how-to-use-delta-synchronization-with-odata-api.html
Hey Tim,
Have you ever used this with Power BI? I followed the instructions here to setup the incremental refreshes here: https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
However, when I had it setup, I got the warning message saying that it was unable to tell whether my feed supported query folding. Signs here point to no query folding, which, if true, means Power Bi won't be able to handle the incremental refresh, correct? I started the refresh on my 80+MB dataset to see if it would work anyway, and got to 25 and stopped it. it shouldn't have been more than 10. Any idea? Maybe I set it up incorrectly?
Bummer. I haven't tried it personally. There are certain things that are only available in Power BI Premium and maybe this is one of those things.
I did learn this recommendation from an Acumatica developer webinar this week. I'd been hesitant to rely on this field, but this makes me more confident to try it:
https://twitter.com/TimRodman/status/1204576241459879937?s=19