Incremental Refresh Option not available

[amybirc77]

Hi All,

I am using Version: 2.97.863.0 64-bit (September 2021) desktop Report Server version. I have created 2 params RangeStart (date/time) and RangeEnd (date/time) and on the desired DATE Field (DateOfService) also (date/time) format.  I added the custom filter . Applied the changes and when I right click on the table I do not see an option for Incremental Refresh. Any suggestions?

Thanks

[v-binbinyu-msft]

Hi @amybirc77 ,

Incremental refresh only support Power BI Service, could not set incremental refresh in Power BI Report Server.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amybirc77]

@v-binbinyu-msft thanks, any alternate solution as the data that I am pulling form the SQL Server table has 4 million rows and it keeps growing.

Thanks

[v-binbinyu-msft · Accepted solution]

Hi @amybirc77 ,

 Sorry, so far, to my knowledge, there is no alternate solution.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.