Hey All,
We have a ODBC that connects to SQL Server which we use Power BI for reporting. Is there a way to trigger an event in NetSuite to do a data refresh?
For example, when accounting period is marked as closed. Let this be the action to refresh the dataset in SQL Server and create a data snapshot.
The concern is if we decide to schedule the snap to be on the 1st of every month, the accounting period could still be active. We are trying to find a way to only snap when the period gets marked closed but not sure if it is possible to have such a event trigger in SQL Server.