Skip to main content

Power BI

Needs Votes

Make adding or updating measures faster in Power BI Desktop

Vote (3) Share
Niklas M's profile image

Niklas M on 16 Nov 2019 23:34:46

Writing measures is an extremely important and common task in power bi desktop. After a while, when building a big model with lots of measures, any editing of measures becomes extremely tedious and slow. Power Bi desktop "thinks and thinks" and I have to sit there waiting just staring at the screen. It kills workflow speed. Creating a new, or editing an existing measure takes a really long time. Just sitting around waiting for power bi desktop to "think".
It feels to me as this is due to poor optimization of the desktop software.
For example, sometimes I open up a measure, edit it, then edit it back to be exactly as it was before. When I hit return and the measure is to "save its changes" the process takes just as long as if I just wrote a new measure. There were zero changes made to the measure!? This is just an example pointing to that there are probably lots of performance improvements / tricks you could do to speed up measure handling.

Comments (1)
Niklas M's profile image Profile Picture

Brennan Deschambault on 13 Sep 2024 15:08:34

RE: Make adding or updating measures faster in Power BI Desktop

Note that this issue compounds as the size of your data within the PBIX file grows. As a work around, I have resorted to filtering out most data when performing development on measures. I don't understand why creating, modifying, deleting, moving, etc measures is dependent on the amount of data, as these are schema definition changes. Microsoft must have some sort of checking against underlying data as measures are compiled after a change.