Is it common that adding a new measure, or editing a measure, is very slow (about 60s) ?

[paul_sanders]

I have a model where the act of adding a new measure in the PBI Desktop takes 60s , just to get to the point where can even edit the DAX! Then, however simple the DAX is, another 60s after hitting enter.  Any subsequent change, even to a comment - another 60s. 

The model isnt huge, and this is on a machine that processes the data and renders reports fine - it's just the act of editing metadata that is absurdly slow.  

I see posts where people mention having hundreds of measures, and my model is nowhere near that size.

Is this a common issue, and any way to avoid?

Thanks

[paul_sanders · Accepted solution]

I discovered that the issue was a column using a temporal function Today(), that was getting recalculated on every model change (and resulting in other calculated columns also getting recalculated).

In the absence of the UI option to disable AutoRefresh (that exists in PowerPivot), I replaced references to Today() with a new column sourced from PowerQuery, that will only change on data refresh.    

[TheoC]

Hi @paul_sanders 

Does this happen to all of your PBIX files or one specific PBIX?

Cheers,

Theo

[paul_sanders]

Thanks for reply Theo.

I discovered that the issue was a column using a temporal function Today(), that was getting recalculated on every model change (and resulting in other calculated columns also getting recalculated).

Regards,

Paul

[paul_sanders]

Thanks for the reply.

Yes, I'm on the latest version of the desktop.   I also have that intermittent hang issue, but this is different. Here it is consiststently poor perfomance with the specific operation of adding/editing any measure. 

[bcdobbs]

Are you the latest version of power bi desktop. I saw some post saying people had experience hangs. I "think" Microsoft released a second December release so may be worth just downloading it and trying an update.