Forum Discussion
Power BI Object Model Turning off the Calculation
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?
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
Any one?