Forum Discussion

visuresh's avatar
visuresh
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Solved

Incremental Refresh does not pull all the data for the defined time duration

I have defined the parameters right and configured settings correctly. Query folding works. The data refreshes only for the value specified in the RangeStart and RangeEnd parameters and not for the t...
Need Help
  • visuresh's avatar
    visuresh
    5 years ago

    I cofirmed that the partitions are correct and data is populated. If I remove the reference query, the incremental refresh works fine. 

visuresh's avatar
visuresh
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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?

deanismael's avatar
deanismael
Icon for Advocate II rankAdvocate II
5 years ago

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?