Power BI Object Model Turning off the Calculation

[Anonymous]

I am using VBA in Excel and the PowerPivot Object Model to Automate the creation of my DAX Meaures within the PowerBI Model.

https://msdn.microsoft.com/en-us/vba/excel-vba/articles/about-the-powerpivot-model-object-in-excel

The Problem I am Experiencing is that, Every Call to the measure create Method Recalculates the Model , So as the Model Grows the Execution Takes longer and Longer as it Recalculates the Model after every Addition and each time the Recalculate is incrementally longer

Is there a way to Disable the Recalculation, so ht all measures can be added with out recalculating the model and then Recalculate the Model Once at the end?

[Eric_Zhang]

---

@Anonymous wrote:

I am using VBA in Excel and the PoerBi Object Model to Automate the creation of my DAX Meaures within the PowerBI Model.

The Problem I am Experiencing is that, Every Call to the measure create Method Recalculate the Model , So as the Model Grows the Execution Takes longer and Longer as it Recalculates the Model after every Addition and each time ithe Recalculate is incrementally longer

Is there a way to Disable the Recalculation, so taht all measures can be added with out recalculating the model and then Recalculate the Model Once at the end?

---

@Anonymous

What does "PoerBi Object Model" refer to, would you mind sharing any background or link?

[Anonymous]

its a typo for PowerBi Object Model but actually I should hav  said  the power Pivot Object Model

https://msdn.microsoft.com/en-us/vba/excel-vba/articles/about-the-powerpivot-model-object-in-excel

[Anonymous]

Any one?