Incremental refresh is not working like i expected

[demorate]

Hi Guys I am having trouble with incremental refresh, I have a Pro account and the incremental refresh was release for pro account, so my problem is that after setting params and and refresh the incremental refresh is not working like I expected, is not loading data before the RangeStart and is updating data from 3 days ago when I set on the configuration that updated data from 1 day ago and if the updated_at column was modified

My Range

Column filters

Incremental Refresh setting

Here is my problem:

I have 50.028 rows

29 are before 01/02/2020

and 49.999 after 01/02/2020

So powerbi are just loading data created after RangeStart

What happen with my 29 row before 01/02/2020 ??

and if I update a row from 3 days ago why when I refresh is detecting the change when i set that just use the updated_at colunm

I am using SQL-Server on localhost

Thanks and forgive me english

[v-jayw-msft · Accepted solution]

Hi @demorate ,

Incremental refresh policies are defined in Power BI Desktop and applied when published to the Power BI service.

For your first question, 29 rows won't be refresh.

And to be honest, i don't understand your second question "and if I update a row from 3 days ago why when I refresh is detecting the change when i set that just use the updated_at colunm".

Here's the official document for your reference:

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-jayw-msft · Accepted solution]

Hi @demorate ,

Incremental refresh policies are defined in Power BI Desktop and applied when published to the Power BI service.

For your first question, 29 rows won't be refresh.

And to be honest, i don't understand your second question "and if I update a row from 3 days ago why when I refresh is detecting the change when i set that just use the updated_at colunm".

Here's the official document for your reference:

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[demorate · Accepted solution]

Hi @v-jayw-msft Thanks, yes my problem was that i hadn't published my pbi desktop to Powe Bi service

[mwegener]

Hi @demorate,

did you upload the PBIX to the service? The incremental refresh only works there.

[demorate]

Hi @mwegener Thanks for your answere, yes that was exactly my problem.