Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Dataset incremental refresh parametrization

Hi, is there a way to parametrize fields for incremental refresh such as data from the past for full load and incremental refresh frequency like from the image. 
We have a lot of datasets and it is inconvinient to manually go over each and set those and mainitain.

So is there some API or way to have more control in setting this up?

 

Thank you!

 

 

 

 

 

momirbeljic_0-1699532301480.png

 

3 REPLIES 3
Anonymous
Not applicable

Thank you @lbendlin for your response!

Do we need to setup RangeStart and RangeEnd parameters for each table in a semantic model even if we have defined incremental policy on dataflow like above?
For example for the  lineage from the attached image there is dataflow that has setup incremental policy for each table in semantic model.

So if we have setup dataflow incremental policy with defined "Store rows from the past", "Refresh rows from the past" parameters and selected "Detect data change" then do we need to have also setup RangeStart and RangeEnd parameters for each table in semantic model refresh in the downstream?

 

Thanks!

momirbeljic_0-1699948297422.png

 

It is totally up to you where you want to set up incremental refresh. You can have it in datasets semantic models, dataflows, both, or none.  My personal opinion is that it only makes sense in datasets semantic models. That is just an opinion based on the desire to arrive at the simplest possible solution (Occam's razor).

lbendlin
Super User
Super User

The dialog you are showing is for dataflows, not datasets semantic models. You have no control over the parameters in a dataflow, they will be added for you.  In a dataset semantic model scenario you have to create RangeStart and RangeEnd yourself, and you can decide how to integrate them into your query (and when).

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors