Forum Discussion
Incremental refresh is loading data only within the parameters date range after refresh in service
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 _ Rongtie
If 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