Have you ever witnessed running a report in the Business Intelligence Development Studio only to see data that you know does not exist anymore in your SQL Database?
In certain circumstances, when previewing a report in BIDS, the environment bypasses getting data from SQL Server and instead retrieves the data previously cached.
If you don’t want to see the cached data, you can do 1 or 2 things:
1) Click the refresh icon on the toolbar when previewing your report.
2) Change the ‘CacheDataForPreview’ value to FALSE in the RSReportDesigner.config file located at C:\Program Files (x86)\Microsoft VisualStudio\2017\Community\Common7\IDE\CommonExtensions\Microsoft\SSRS. (SQL Server 2017)
