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.
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?
Data is present in all the partitions
Worth double checking if you have any query, page or visual filters enforcing limits on the data, but as I understand it, your original question re. incremental refresh is not the issue here.