Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Incremental refresh - publish

Community -  I am not clear on this comment below from the documentation.       Let's say I set up incremental refresh on a dataset.   Publish.   Then I get asked to create a new measure on that da...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous Essentially correct. The dataset would be replaced by whatever is in the PBIX file. You can avoid this by using something like ALM Tooklit or Tabular Editor. ALM Toolkit allows you to compare a dataset in the Service (Premium) with a PBIX, identify the model differences and update the model (not the data) with just the changes identified.

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

Hey Anonymous ,

 

re-publishing a dataset Power BI Desktop will re-create the initial partitions, meaning an initial load will be necessary. Things can become more and more complex, as on a certain point in time the initial load will no longer succeed due to the amount of data.

 

It's very complex to use incremental refresh without having a Premium capacity. A Premium capacity provides the feature: XMLA endpoint. The XMLA endpoint can be used by the ALM Toolkit (http://alm-toolkit.com/). The ALM toolkit allows to deploy a measure without overwriting the existing partitions.

 

Hopefully, this provides some new ideas on how you can tackle your challenge.

 

Regards,

Tom