Forum Discussion

tstad9i's avatar
tstad9i
New Member
3 years ago
Solved

visualizations not updating after data refresh

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 a...
Need Help
  • tstad9i's avatar
    tstad9i
    3 years ago

    @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.

amitchandak's avatar
amitchandak
Super User
3 years ago

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's avatar
    tstad9i
    New Member
    3 years ago

    @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.