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
- 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