Table in Subscription email is not up-to-date

[Anonymous]

The Subscription email sent to all users after the daily data model refresh contains a snapshot of the report page that shows the single table on the page is not updated. The date slicer on the same page is fine and shows the latest date. The table at issue here is consistently a day behind (sorted descending on the slicer's date field). When I go directly to the report itself the table is up-to-date.

It seems as if the snapshot is taken just prior to the table completing its refresh.

Please assist. Thanks!

[v-qiuyu-msft]

Hi @Anonymous,

I have tested with SQL database with import mode but not reproduce the issue. Which data source does the report get data from? Which connect mode do you use, import, directquery or connect live? 

Best Regards,
Qiuyun Yu 

[Anonymous]

Thanks for responding. The data is sourced from Redshift via ODBC.