Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Deployment pipelines and Incremental refresh

Hi guys!

Is it possible to use pipelines when I have a table with Incremental refresh in the model?
I also want diffrent incremental refresh settings between test and production.



Super User II
Super User II

Hey @tobiasnygren ,


the answer to the first part of your question is - yes. Incremental refresh is supported by deployment pipelines.

This is the aricle: Deployment pipelines process - Power BI | Microsoft Docs


The second part, diffrent incremental refresh policies per stage seems to be difficult. I recommend, tweekig the refresh policies using Tabular Editor and make some thorough testing.




Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Do you have any tips on how to do it in Tabular editor.
I want to change "Store rows where column "X" is in the last X months" in the incremental refresh dialog.
In the test workspace I'm fine with one months of data because of the dataset is big.
And in the production database I want to have 2 years of data.

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.


Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.