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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
aaronjschmidt
Frequent Visitor

Can't edit Direct Lake Semantic Model to reduce size: Resource Governing error

We have a P1 capactiy with a Lakehouse.  I started building a custom Semantic Model, and then (when trying to add a Measure), got the following error:

Resource Governing: This operation was canceled because there wasn't enough memory to finish running it. Either reduce the memory footprint of your dataset by doing things such as limiting the amount of imported data, or if using Power BI Premium, increase the memory of the Premium capacity where this dataset is hosted.

I thought I can drop one of the tables in my model or hide some columns.  But now I can't make ANY changes to the model because I keep getting the same error.  If the model is already over size, how do I change it to reduce the size?

 

UPDATE:  The next day, I noticed (using Bravo for Power BI) that the size of my semantic model was significantly reduced.  I'm guessing it has to do with some data getting evicted from memory.  During my initial testing, I was using a report that pulled back a lot of records, so it chewed up all the available memory.  But I guess it reset somehow (through the magic of Direct Lake), and I was able to edit it today.

 

I also came up with another workaround by using Power BI ALM Toolkit to merge part of my "too big" model into a mostly blank model (after enabling writing via the XMLA endpoint).

2 REPLIES 2
v-zhouwen-msft
Community Support
Community Support

Hi @aaronjschmidt ,

Regarding your question, I think you can try to use a third-party tool to modify the semantic model, I have searched, I think 'Tabular Editor' may be able to solve your problem, 'Tabular Editor' can directly edit the model's tables, columns, relationships, metrics and calculated columns.

Tabular Editor 3

The official documentation describes how to use the 'Tabular Editor' to connect to the direct lake semantic model:

Direct Lake Semantic Models | Tabular Editor Documentation

 

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I thought that too, but even Tabular Editor gets the same error when it tries to apply the changes.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors