Forum Discussion

amybirc77's avatar
amybirc77
Icon for Helper II rankHelper II
2 years ago

Refresh taking more time

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 kee...
Need Help
amybirc77's avatar
amybirc77
Icon for Helper II rankHelper II
2 years ago

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's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
    amybirc77
    Icon for Helper II rankHelper II
    2 years ago

    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