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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Working in a large Power BI Desktop file - very slow to add changes to the datamodel (500+ measures)

Hi

 

I have a large datamodel (200mb+) with star schema (dimensions and fact tables) and many many measures (500+).

In the beginning, adding measures was very quick but now it takes forever to make any changes to the datamodel.

 

Adding a measure takes around 1-2 minutes.

  • 20+ sec waiting on the formula bar to be ready,..
  • 20+ sec wait for the measure to be added..
  • 20+ sec for formatting changes..

 

The same goes for other changes like, adding a calculated column or renaming columns.

Very frustrating to work with and takes forever to make changes.. 

 

Anyone else been experiencing something similar as the datamodel gets big?

 

PS: I've a i7-processor and 24GB RAM so computer power should not be an issue 🙂

 

Kristoffer

5 REPLIES 5
wi11iamr
Advocate II
Advocate II

Same problem.

Any progress made?

Haven't delt with this problem on the desktop app, however thinking tabularly here I can advice the following:

1. reduce the size of the data model by pointing its data sources to something with a smaller footprint.

2. once you've added the new measure, publish it to a PBIT template

3. open the PBIT and point it to the full data set, this way you load the enitire data model in the final PBIX

 

It would be good to have a look at your trace files to get an idea what is it taking that long to load.

Anonymous
Not applicable

Thanks for the input.

 

I have tried to work with just a Power BI template (only metadata) and experience the same issue (slow, long wait) when adding measures / making adjustments to the data model. I think that the number of measures affects the time to add changes, but it doesn't make sense that it should! Same datamodel with less than 100 measures is really easy to work with and to make adjustments to. I get the similar experience developing SSAS tabular models. 

 

Good idea to look at the trace file. I will do that.

Thank you

PavelR
Solution Specialist
Solution Specialist

Hi @Anonymous. Unfortunately I had (have) same problems...

 

Regards.

Pavel

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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