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.
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?
So you've duplicated the query, added steps to break folding and the result is that one visual is filtered based on the rangeStart / rangeEnd parameter settings and the other (which is built from the second query) is complete when viewing via powerbi.com?
I did not duplicate but referenced only