cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
texmexdragon
Memorable Member
Memorable Member

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 dataset, and I re-publish it.   Does this mean the incremenatal refresh is now no longer valid?

 

Incremental refresh for datasets in Power BI - Power BI | Microsoft Docs

 

Configuring incremental refresh is done in Power BI Desktop. For most models, only a few tasks are required. However, keep the following in mind:

  • When published to the service, you can't publish the same model again from Power BI Desktop. Republishing would remove any existing partitions and data already in the dataset.
1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@texmexdragon 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.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

Hey @texmexdragon ,

 

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



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
Greg_Deckler
Super User
Super User

@texmexdragon 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.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.