I'm curious as to the results of the following test:
1. Recreate the workbook.
2. Connect live to the database.
3. Create a second connection the database and create an extract.
4. Look at the data with the live connection and take a screenshot.
5. Replace the data source to the extract (right-click live data connection and select "replace" > Choose Extracted Data Source) and take a screenshot of the view.
Does the view change at all? I'm looking to see if everything will be the same in a 1-1 comparison.
Is it the same SQL ?
Can you share the SQL ?
Are you using any Case statements ?
Also please check the where condition maybe its being omitted in live connection Flag1