If you have a SQL database data source with data coming from an external source (i.e. MYOB), then you should create a report which allows user to manually refresh data.
Your report should have:
✅ Figure: Good example - A report with a radio button allows you to refresh data and a table showing the history