Forum Discussion
Incremental refresh is loading data only within the parameters date range after refresh in service
Hi Anonymous ,
Please have a check.
One thing to check is whether the data you are expecting to see beyond the date range actually exists in the data source. If the data does not exist, then it will not be loaded even if you have set up incremental refresh.
Another thing to check is whether the incremental refresh settings are correctly applied to all the tables. It's possible that there may be a mistake in the settings for the tables that are not showing the expected data. You may want to double-check the settings for those tables to make sure they are set up correctly.
How to Get Your Question Answered Quickly
If it does not help, please provide more details.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Rongtie,
The data exisits in the data set. I can say this confidentaly becasue the other report on the same dataset without the incremental refresh is picking up the entire range's data. Regrading double checking the tables' setting, I will do it once more. However, please help me to understand can the merge tables step cause any hindrance in incremental refresh?
Or is it possbile that the table where the data is loading finally (and which is used for the visuals) is created in Power Query by appending all the other sales tables, which is why incremental refresh is failing?
Thank you.
Best Regards,
Neha
Hi Anonymous ,
It is strange that no error message appears.
Check whether the RangeStart and RangeEnd parameters are being passed correctly to the queries. You can check this by looking at the query execution plan and verifying that the parameters are being used to filter the data.
And please make sure you have successfully set up incremental refresh.
Please pay attention to the limitations.
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Rongtie,
Thank you for reposnding. I am still stuck with this incremental refresh.
While checking the query folding step in Power Query, I found this
Is the RangeStart and RangeEnd parameters passing correctly to the queries?
Please look into the same and confirm.Thank you.
Best Regards,
Neha