topic Power BI Object Model Turning off the Calculation in Developer

Power BI Object Model Turning off the Calculation

Anonymous — Thu, 12 Apr 2018 22:14:05 GMT

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?

Re: Power BI Object Model Turning off the Calculation

Eric_Zhang — Mon, 18 Dec 2017 09:27:23 GMT

@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?

Re: Power BI Object Model Turning off the Calculation

Anonymous — Mon, 18 Dec 2017 14:55:49 GMT

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

Re: Power BI Object Model Turning off the Calculation

Anonymous — Thu, 12 Apr 2018 22:15:20 GMT

Any one?