3 Replies Latest reply on Apr 5, 2017 11:02 AM by Rahul Upadhye

    live SQL workbook in server is not reflecting/loading new dates/data

    emilie reimer

      hi all:

       

      forgive me if this is simple, but I have a workbook published to server that runs live queries against SQL Server.  each time the workbook is loaded on server it should reflect 'yesterday' data.  but when I load the workbook today (april 5th), for example, I see the greatest date for the field campaign_end is from late February:

       

      c_end.png

      if I run the query that is driving this selector directly in SSMS, you can see that there are 'yesterday' dates:

       

      sql_c_end.png

      back in the browser, if I drag the selector to the left and then all the way to the right, it 'refreshes' to yesterday as expected:

       

      after_refresh.png

      Question: why does each page in the story not automatically load to show the greatest date 'yesterday'?  I have tried clearing cache and reloading the page after initial load.

       

      I have attached a packaged workbook.

       

      Environments:

      Tableau Desktop 10.1.1

      Server 10.1.1.

      IE 11, Chrome

       

      thanks!