CODEWITHSUNDEEP
powerbi
Beyza
Beyza

Reputation: 149

PowerBI Incremental Refresh Parameter

I have a question about PowerBI incremental refresh parameters. I couldn't understand the role of parameters. How can I define the parameters? Actually I mean is the parameter range important?

Upvotes: 3

Views: 2411

Answers (1)

Andrey Nikolov
Andrey Nikolov

Reputation: 13460

Incremental refresh uses two parameters, named RangeStart and RangeEnd (names are case sensitive). When published, the service will automatically change the parameter values, to load only the data added after the last load, e.g. only for the last day.

Incremental refresh isn't designed to support cases where the filtered date column is updated in the source system, only to load newly added rows. If an update is interpreted as an insertion and a deletion, not an actual update, it might work. If the deletion occurs in the historical range and not the incremental range, it won’t get picked up.

To define the parameters with default values, in the Power Query Editor, select Manage Parameters and add their initial values which will filter the initial load. Once published, the parameter values are overridden automatically by the Power BI service.

enter image description here

With the parameters defined, you can then apply the filter by selecting the Custom Filter menu option for a column.

enter image description here

Ensure rows are filtered where the column value is after or equal to RangeStart and before RangeEnd. Other filter combinations may result in double counting of rows.

enter image description here

Verify queries have an equal to (=) on either RangeStart or RangeEnd, but not both. If the equal to (=) exists on both parameters, a row could satisfy the conditions for two partitions, which could lead to duplicate data in the model, i.e. the same order to be loaded in the model twice in two consecutive loads.

For more details see Incremental refresh in Power BI Premium.

Upvotes: 3

Related Questions