Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Incremental refresh and real-time data

Hi, I am trying to configure an incremental refresh to get todays's real-time data and cacahe the data before today.

However, I find that the Today's data is not updating in BI after the DB gets inserted more records and it only shows the data which has been refreshed in BI service.

May I know why and how I could fix it? because its not working at all for Today's data.

Appreciated with any helps

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , Make sure the date on which you are using the incremental setting is a truncated date with no timestamp( But datatype should be datetime) 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    amitchandak Thanks, 

    I am already using the Date/Time for setting up the incremental refresh. 

    Still, the BI doesn't get the most updated data from today's but the last refreshed data only

     

     

    And I found that for today (Oct 25), there is 7974 rows on BI but in the SSMS partition,  7974 is showing on Oct 24