Incremental Refresh based on Status

[joshua1990]

Hello everyone!

I have a connection with our ERP-Data. One table contains every order in our system. Within this table we can see which status each order has and when the requested date was/ is.

Basically the structure is like this:

• Nr
• Date
• Status
• Area
• etc.

Now I would like to use the incremental refresh to reduce the data pull.

But this should be based on the date and the status.

I need just to refresh rows where the status is <75 - regardless of the date.

Is there any chance to use an incremental refresh here?

[v-kelly-msft]

Hi @joshua1990 ,

Based on my research, it is not supported yet currently.Incremental Refresh is  only refreshing when the datetime column meets the parameters.You can propose your  idea and add your comments via below link to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@joshua1990 , refer if these can help

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/