Skip to main content

Power BI

Needs Votes

import measures from a pbix that access the model on the service

Vote (14) Share
Crispin Burdett's profile image

Crispin Burdett on 14 Sep 2017 18:24:35

Once a model on the desktop has a lot of measures it becomes very slow to add new measures - several minutes - this means that adding a dozen measures for a new requirement can take a very long time. However, it is very quick to add new measures to a new .pbix that accesses that same main model via the service. But then those measures are only available to that .pbix. What would be a great way to get around the issue would be to be able to import these new measures into the main model once they have been developed in the separate pbix as that could be done as one batch and it would not matter if it took some time.

Comments (3)
Crispin Burdett's profile image Profile Picture

Josh Moody on 17 Sep 2020 22:21:28

RE: import measures from a pbix that access the model on the service

I'd like to add that writing a new measure is slow too. If my column name is long or I need to go look something up, clicking away from powerbi desktop gives me a "waiting..." dialog that can last minutes. The measure is completely invalid and half written, but powerbi desktop wants to evaluate it and that takes a terribly long time. I waste so much time on powerbi desktop's "waiting" dialog

Crispin Burdett's profile image Profile Picture

Bryant on 05 Jul 2020 23:16:47

RE: import measures from a pbix that access the model on the service

What a great suggestion!

Crispin Burdett's profile image Profile Picture

Power BI User on 05 Jul 2020 23:06:14

RE: import measures from a pbix that access the model on the service

I can't believe this doesn't have more votes! I also find it incredibly tedious to add new measure across different pbix files. We have a different pbix for each client and whenever we upgrade our template we either have to make all the client related customizations in each new report and connect new data or we have to manually add each measure to each report. It's so counter intuitive and surprising that this would be necessary in such a powerful program.