Forum Discussion
po
Post Prodigy
6 years agoIncremental Refresh not working?
Hi, Have set up incemental refresh on a table and first refresh completed and had sql similar to below. Expecting subsequent incremental refreshes to be much quicker When look at database...
- 6 years agoHi there
If you can have a look in Power Query where you configured the RangeStart and RangeEnd and see if you can view the Native Query when right clicking on the last step.
If you can it should query fold (which will allow for incremental refreshing).
If no query folding then it cannot complete the incremental refresh.
GilbertQ
Super User
6 years agoHi there
If you can have a look in Power Query where you configured the RangeStart and RangeEnd and see if you can view the Native Query when right clicking on the last step.
If you can it should query fold (which will allow for incremental refreshing).
If no query folding then it cannot complete the incremental refresh.
If you can have a look in Power Query where you configured the RangeStart and RangeEnd and see if you can view the Native Query when right clicking on the last step.
If you can it should query fold (which will allow for incremental refreshing).
If no query folding then it cannot complete the incremental refresh.