Forum Discussion

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Refresh failure after changing granularity for Incremental Refresh configuration

Hello everyone,   Initially, I had configured Incremental Refresh for my Dataset as below:   But then, I read somewhere it is better to configure in months as it creates partitions. Hence, ...
General Comment
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi rajulshah 

Could you succeed to refresh if you set store and refresh by years?

Please check your configure of your gateway.

I have a test that build a sample report and change interval from 4 years to 48 months.

My Sample Data:

RangeStart: 2015/10/31 0:00:00

RangeEnd : 2020/12/31 0:00:00

Custom Filter:

Set Incremental Refresh in field.

Publish the report and refresh the dataset in service manually.

Refresh result:

First Refrsh is 4 years, second and third are 48 months. 

My result is correct.

For more info to Incremental Refresh, you may refer to this blog.

If this reply still couldn't help you solve your issue, please show me more details about your refresh failure log.

 

Best Regards,

Rico Zhou

 

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