Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Power BI Object Model Turning off the Calculation

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?

Need Help
Tips and Tricks

3 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    8 years ago
    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?