Forum Discussion

amybirc77's avatar
amybirc77
Helper 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
Helper 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
    Community 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
      Helper 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