Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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.    
Need Help
  • acecinati's avatar
    acecinati
    4 years ago

    The solution I found is to mantain the same incremental refresh policy, but filtering the test table with a parameter in order to reduce the amount of data.

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
5 years ago

Hey Anonymous ,

 

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.

 

Regards,

Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

    • acecinati's avatar
      acecinati
      Icon for Advocate I rankAdvocate I
      4 years ago

      The solution I found is to mantain the same incremental refresh policy, but filtering the test table with a parameter in order to reduce the amount of data.