Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Visual Table Does Not Have Same Data as Underlying Data Table

I have an underlying data table that is set up as a direct query to a SQL server management studio table.  The table is being brought in and transformed using a "is latest" filter on the datetime so it only shows the latest row of data.  When I create a visual table based on this data, the row is not matching what is in the underlying data. I cannot for the life of me figure out why.  I have the visual table page set to refresh every 5 minutes. 

 

Since the underlying data table is a direct query, it should always have the most current row of data.  See screenshots.  Don't pay attention to the null values in the underlying data.  At the time of the screenshot, the underlying data table had the most current row of data at 10:28, which is correct based on using the "is latest" filter.  The visual table is showing 10:13.  I just want the visual table to always have the same data from the underlying table.  

 

Underlying Data:

 

Visual Table:

 

   

2 Replies

  • ahmedoye's avatar
    ahmedoye
    Responsive Resident

    Hi Anonymous , will you try to change the style of your Refresh from "Auto Page Refresh" to "Change Detection"?

  • Anonymous's avatar
    Anonymous
    Not applicable

    I can try that.