Forum Discussion
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 time duration specified in the incremental refresh settings.
I cofirmed that the partitions are correct and data is populated. If I remove the reference query, the incremental refresh works fine.
13 Replies
You're refreshing in the Service (not Desktop) which is where you're observing these persistent filters? If you're running a Premium capacity, can you validate if the data has been partitioned correctly.
Yes, I am observing this in Service. To verify tha partitions, should I open the model in SSMS?
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 cofirmed that the partitions are correct and data is populated. If I remove the reference query, the incremental refresh works fine.
As mentioned, the start / end date parameters appear to have been configured correctly. Are you observing the same behaviour in Desktop and app.powerbi.com?
Per your original comment...
visuresh wrote: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 time duration specified in the incremental refresh settings.
Can you confirm if this is the case as earlier in the thread you confirmed the partitions were created and backfilled correctly which indicates it is not an incremental refresh issue.
Hi visuresh ,
Not very clear about the situation. Let say you have filtered data from July to October and set store last 3 months' data and refresh last one month's data, which part of the data was refreshed in your case?
Best Regards,
Jay
