Reply
Regular Visitor
Posts: 16
Registered: ‎10-19-2018

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-refresh) with the parameters :

Start range : 01/01/2018 00:00:00

End range : 15/01/2019 00:00:00

Incremental parameters :

 

 1.png

 

Here below the steps I followed :

 

First, I load the table "Historic" (excel file) which the values of the Report Date/Backlog L1/Backlog L2/On hold by L1/On hold by L2/Modification Date columns (see capture below).

2.png

 

Then, each day after, we upload the same file which contain only the daily figures – see below.

 

 3.png

 

The aim of the incremental refresh is to keep the historic datas and complete them with the new values of the day and this every day.

 

That work for the first refresh but for the others,

4.png

 

The days after, the daily refresh replace the Day before upload – see below:

 

5.png

 

Can you help me please?

 

Sincerely

 

Luca BOROME

Community Support Team
Posts: 5,709
Registered: ‎09-21-2016

Re: Incremental refresh

Hi @luca_borome,

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor
Posts: 16
Registered: ‎10-19-2018

Re: Incremental refresh

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...

 

 

Frequent Visitor
Posts: 5
Registered: ‎01-16-2019

Re: Incremental refresh

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.