Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Incremental refresh is loading data only within the parameters date range after refresh in service

Hi, I have 5 sales tables, 1 article table, date table and 1 store table. I have used these tables to further create a compiled sales table. In Power Query, I have implemented the RangeStart & Range...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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