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.
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.
I have setup incremental refresh on one of the Power query. Later I have referenced this query and created other queries with operations that are not allowed for Query folding. And the data from the later queries is used in the visual. I am expecting that incremental refresh to work on the original first query. Is this approach ok?