Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Incremental refresh

Hello,   I have an issue on Power BI regarding the incremental refresh.   I have followed the procedure given by Microsoft (https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-r...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

In your scenario, the incremental refresh kept the historic data before 13/01/2019 while it override daily record after that date, right? Have you tried re-publishing the report to service? Have you tried to change the value for "Refresh rows in the last"?

 

Regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    Yes it is exactly that what is happen ! I re-publish my report many times and made many tests with the incremental refresh parameters (1 year/1year, 1 year/2 days, 1 year/1 day) and this doesn't work...

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      As you have stated to refresh the last 2 days that is exactly what is happening, it is bring in the new record for current day and noting that the record for previous day has been deleted and so deletes that record in the target. Leave the previous day in also or refresh only 1 day.