Data from Data Gateway is not updated until I select "Select data from source"

Sventek — Tue, 09 May 2023 10:05:22 GMT

Hi there,

I am trying to something rather simple (I think) with the SaaS version of QlikSense, which is to create a sheet that shows the current count of records in an SQL database.

I have done the following:

Set up a Direct Access Data Gateway to be able to access the database
Added the table to my app using Data Manager / `Add data` feature (using the auto-generated loading script)
Created a sheet that counts the records

Initially, this works fine. However, once the record count in the source table changes, the sheet doesn't update, even if I press the app's `Load data` button before and wait for the loading to finish. Instead, I have to open the table in the Data Manager and hit the `Select data from source` button to refresh the data in QlikSense.

Is this expected behavior? Shouldn't the data in my app be refreshed simply by hitting the `Load data` button?

I would appreciate some help.

Thanks a lot!

topic Data from Data Gateway is not updated until I select "Select data from source" in Connectivity & Data Prep

Data from Data Gateway is not updated until I select "Select data from source"