Forum Discussion
Incremental refresh is not working like i expected
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
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.
Hi Anonymous Thanks, yes my problem was that i hadn't published my pbi desktop to Powe Bi service
4 Replies
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.
Hi Anonymous Thanks, yes my problem was that i hadn't published my pbi desktop to Powe Bi service
