Forum Discussion

aume1's avatar
aume1
Icon for Helper I rankHelper I
4 years ago

Incremental Refresh is not working when parameters are set

Hi,    I have a report that has Incremental Refresh (henceforth IR) applied to it. The purpose of it is to let the report store the past 10 months of date + current month while only updating the la...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi aume1 ,


It looks like the problem may be caused by a time zone conflict. Troubleshooting

 

Try again and give me feedback.  Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aume1's avatar
aume1
Icon for Helper I rankHelper I
4 years ago

Thanks for your reply. I do not think the time zone conflict is an issue as it is set to the time zone where I live and scheduled refresh is set accordingly. 

 

The refersh now works with RangeEnd set to a date in 2025, but I have a question on how the "Store Columns in the last..." and "Refresh rows in the last...". From the documentation, I understand that "Store..." works in a way that it loads the speicified complete months (10 months, in this case) plus the current months. My question is, once this month is complete, does PBI Service delete the entire month from the Historical Period once next month starts? My current set up is 10 months from March 2021, so once Feb 2022 starts, is the entire March 2021 data removed?