Hi,
We have an evolving MS SQL database which we have connected to several Qlik Sense Cloud Apps. The connection is no issue and the initial services available through Data Manager work well, however if/when we make changes to existing fields or values within the source database, the results don't get reflected in Data Manager. They do make their way through to the Sheets, but I'm unable to use Data Manager for any cleaning/sorting/etc as the snapshot of the data it presents its now old and incorrect.
I have tried refreshing tables, reloading data and deleting and re-adding the data to the App, but the view is locked to the initial upload snapshot. This includes if I import the data into another App - the Data Manager snapshot is of the initial view of the data.
Is there something I'm missing to make Data Manager or Qlik Sense completely reload and re-evaluate the data from the source SQL tables?
Thank you.