Refresh taking more time

[amybirc77]

Hi All,

I have a desktop report which is deployed to the report server ( not services). The backend data source is a SQL Server database (VIEW). The report takes 2-3 minutes to refresh. The VIEW keeps growing everyday. The old records do not change, I mean the underlying tables do not do any UPDATE, it is just INSERT. Is there a way when the user clicks on the refresh , it just refreshes the new rows? I know it won't work that way , but just curious if there is a workaround.

Thanks

[Uzi2019]

Hi @amybirc77 
Please check the video for incremental refresh. It will resolved your issue.

https://www.youtube.com/watch?v=tfJXmfUXgu0&t=451s

I hope I answered your question!

[amybirc77]

@Uzi2019 

Thanks, I have 2 dates createdate and modify date and i need to refresh based off both the dates how is that possible?

Thanks

[Uzi2019]

Hi @amybirc77 

you can apply incremental refresh on single date. which ever upatated on daily basis. dont add on both dates in single table.

[amybirc77]

@Uzi2019 sorry for changing the goal posgt, here is the new requirement based off the incoming data, we are getting ID,PAYEYEAR,PAYMONTH. For example 

ID=96131A0205

PAYEAR= 2023 going forward

PAYMONTH= 1 TO 12

We get files on the first day of the month which get loaded into SQL Server table , this has YEAR and month only so need to refresh based on CURRENT_DATE-Month=1

Is that possible?

Thanks

[amybirc77]

@Uzi2019 Thanks, Will try this and update you. Thanks for sharing the video.