visualizations not updating after data refresh

[tstad9i]

hello all,

my visualizations do not reflect changes in source data which is a direct query of view in an Oracle database.  the only thing that changes in the data is the content.  the data types are the same before and after the refresh.  in the power query editor, 'include in report refresh' is check-marked'.  

if I leave the original 3M rows in the source and insert another 3M new rows, the visualizations dislay a total of 3M rows (the originals ones only) from a view that has 6M records.  if I truncate the original 3M and insert only 3M new rows, some visualizations work as expected, others go grey and the tables/matrices go blank.  

anyone have any ideas as to why all visualizations aren't reflecting the new data?

[amitchandak]

@tstad9i , check if there filter added in the power query step. Or are you using SQL query, that is limiting the data

Also check page level and report level filter.

The max result set direct query can give you is 10M rows, so should work

[tstad9i · Accepted solution]

@amtichandak,

thanks for the reply.  you're right, there was 1 filter being applied to all pages that was causing expected data to get filtered out before reaching the visuals.  an upstream source that was populating the source table had a very slight change ( 'ab-cd' expected but replaced with 'ab- cd').  strip out the space and life is good again.