Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
rmoreno
New Member

Create a new measure takes 10 minutes.

Hi, I have a report with 700 measures, and when aI need create one more It's take more than 10 minutes in power Bi Desktop.

Can I do the creation by script?. It's posible disable the working for every creation and only do that at the end of creations of new measures?

 

Thanks,

Rodrigo

7 REPLIES 7
rusgesig
Helper IV
Helper IV

Same, takes me 15 minutes to create a new measure on a 70mb dataset. There are a few dozen measures and lots of inactive relationships. Using DAX editor is instant, so why can't it be instant on the Desktop app?

LocNguyen
Advocate I
Advocate I

I am having the same issue with yours. Since this is an old post, I wonder if you found a solution for this. If yes, would you please share your tips?

Thanks a lot.

v-micsh-msft
Employee
Employee

Hi rmoreno,

 

Well I think currently it is a little hard for me to reproduce your scenario.

Measures should be take so much effects in performance, as it is only calculated when in use. Do you have Variables defined within the Measure? Reference: Measures in Power BI Desktop.

If you mean writing measures using scripts in Power BI desktop, then you may take a look at R Visuals in Power BI Desktop:

Run R scripts directly in Power BI Desktop

By the way, what do you mean by saying "It's posible disable the working for every creation and only do that at the end of creations of new measures?"

Please reply back if you need any further assistance.

Regards

 

 

 

After each creation of measure, appears the message "working on it..." on a MsgBox. This process take 10 minutes or more.

The R Visual scripts don't resolve my problem because I don't have R licence, some that reduce the time was create measures with only 1 registry on my Table, but change the table take 20 minutes.

Same thing here...

But in my case it happens creating anything: Measure/Column/Hierarchy

Any ideas??

Work with a little sample of data decrease this time, but still take so long. When you finish your modifications put all data and publish.

 

Another idea can be split the reports to decrease the number of mesures or columns neaded.

 

rewards,

I have the same thing going on in several files. As far as I can tell it's caused by having a high number of measures and/or calculated columns. There seems to be an upper limit on how many you can add before the file bogs down.

 

I can't share any of them because they're all company data, and there's no way I'm going to take the day and a half it would take to create a demo file with dummy data to reproduce the problem.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors