EP 175: Kaden Webb – Differential Refresh over OData for Generic Inquiries

  • My favorite feature in Acumatica is the ability to connect directly to the data in a Generic Inquiry over OData
  • It's my favorite feature because both Microsoft Excel and Power BI understand OData so you can design reports that are refreshable at the click of a button instead of having to Export to Excel every time you want new data
  • But OData can time out on large datasets
  • That time out problem could be solved with a differential refresh on OData, but I've never figured out how
  • Kaden thinks he has a way to do it so let's find out