Forum Discussion
Incremental Refresh does not pull all the data for the defined time duration
I cofirmed that the partitions are correct and data is populated. If I remove the reference query, the incremental refresh works fine.
You're refreshing in the Service (not Desktop) which is where you're observing these persistent filters? If you're running a Premium capacity, can you validate if the data has been partitioned correctly.
Yes, I am observing this in Service. To verify tha partitions, should I open the model in SSMS?
That's correct. If you workspace is backed by a Premium capacity, grab the connection string from the dataset settings and connect via an Analysis Services connection in SSMS. The partitions will have been created after the initial refresh and can be viewed by right clicking on the table with the incremental policy applied and selecting the 'Partitions' option.
I checked and I did not see "applyRefreshPolicy" in the script. But the partitions are created correctly. I am not sure why "applyRefreshPolicy" is not present though Incremental Refresh is defined for the table.
Is data present in some / all of those partitions?