Incremental update on dataset

[Syndicate_Admin]

Hello!

Could anyone tell me if it is feasible to establish an incremental update of a table in Power Bi Desktop, which has as its origin a Data Flow?

Thank you!

[v-binbinyu-msft · Accepted solution]

Hi @Syndicate_Admin ,

Please try below steps:

1. import the dataflow into Desktop, please confirm the dataflow has datetime type column, and the datasource support query folding

2. create parameters and set the increment refresh policy

3. publish to Service

But you could set increment refresh for dataflow in Power BI Service now, you just need have Power BI Premium (PPU or a Premium capacity subscription).

For more details, you can read related document: Premium features of dataflows - Power BI | Microsoft Learn , Using incremental refresh with dataflows - Power Query | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.