Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

paul_sanders

Terrible performance adding / editing any measure in Power BI Desktop

Submitted by on ‎02-03-2022 07:17 PM

I have a model with about 30 tables, and a reasonable (not excessive) number of calculated columns and measures.

Now adding a measure takes about a minute. It's got considerably worse over time.

So that means you wait a minute before can even start editing the DAX.  Then however simple the measure is, wait another minute after hitting enter. Heaven forbid that you don't the DAX absolutely perfect first time, because it's another minute for every edit.  

 

CPU is basically pegged at 100% the whole time. I understand some impact analysis might need to run - but 100% CPU for a minute?!

 

 

 

 

 

Status: Investigating

You may need to consider optimizing your data model first in Power BI Desktop, see:

  1. Data reduction techniques for Import modeling 
  2. Composite model guidance in Power BI Desktop 
  3. DirectQuery model guidance in Power BI Desktop 

 

In addition, to edit/add DAX formulas in Power BI Desktop, you can try to edit in other tools in advance like DAX formatter, external tools like DAX Studio which could show the performance when you open this report and create DAX formulas in it.

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yingjl
Community Support
Community Support
‎02-06-2022 06:51 PM
Status changed to: Investigating

You may need to consider optimizing your data model first in Power BI Desktop, see:

  1. Data reduction techniques for Import modeling 
  2. Composite model guidance in Power BI Desktop 
  3. DirectQuery model guidance in Power BI Desktop 

 

In addition, to edit/add DAX formulas in Power BI Desktop, you can try to edit in other tools in advance like DAX formatter, external tools like DAX Studio which could show the performance when you open this report and create DAX formulas in it.

 

Best Regards,
Community Support Team _ Yingjie Li

Idea Statuses