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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
marius1106
Helper I
Helper I

How to get Semantic Model storage size MS Fabric

Dear Microsoft,

In my MS Fabric Workspace I have a Warehouse with data and build a semantic model on it. It has the storage mode direct lake. How can I find out which memory size this semantic model has? I read that small models only can have about 10 GB. 

Could you help me where I can find the information?

 

Thanks!

 

9 REPLIES 9
pallavi_r
Super User
Super User

Hi @marius1106 

 

Can you please check the below setting for semantic model and see if this helps.

Go to workspace setting->system storage

 

pallavi_r_0-1744677457422.png

 

Thanks,

Pallavi

 

v-pbandela-msft
Community Support
Community Support

Hi @marius1106,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

suparnababu8
Super User
Super User

Hi @marius1106 

 

You can achieve this by using Memory Analyzer option from that sematicmodel (data model) 

 

Step-1: For example Salesreport semantic model, click on ... and select Open data model.

suparnababu8_0-1744214221987.png

Step-2: After opening the datamodel, click on Memory Analyzer 

suparnababu8_1-1744214306821.png

Step-3: After clicking this , notebokk will open (in my case it is SalesReport_memory analyzer) and run the note book all cells

suparnababu8_2-1744214413487.png

Step-4: Now you will be able see the sematicmodel size.

suparnababu8_3-1744214494371.png

 

Let me know if it works for you.

 

Thank you!!

 

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

Proud to be a Super User!

 

 

 

Hi @suparnababu8 ,

thank you for your help! I tried it but it seems to show only the metadata size of 400KB. In my data model just one table has about 4GB and I want to know the real size. If its because of the storage mode I don't want to change every single table to import mode 😞

 

Hi @marius1106,

Thank you for reaching out in Microsoft Community Forum.

Thank you @suparnababu8  for the helpful response.

Please follow below steps to Check Memory Size in Direct Lake Models;

1.In Direct Lake mode, Power BI only loads data on demand, so Memory Analyzer shows only metadata size (e.g., 400 KB) — this is expected.

2.4GB Table Doesn’t Show Up Because it’s not loaded into memory yet — only accessed during query execution, not during analysis.

3.Use Fabric Capacity Metrics App or Power BI Admin Monitoring to see runtime memory usage.

4.If you need an exact size, create a temporary Import mode copy of the model, run Memory Analyzer, then discard it.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

 

Hi @v-pbandela-msft ,

where can I monitor the runtime memory usage in the Fabric Capacity Metrics App? I can only see the whole storage of the workspace but not the RAM.

Hi @marius1106,

Thank you for reaching out in Microsoft Community Forum.

please follow below steps to Monitor Runtime Memory Usage in Microsoft Fabric:

1.Use Log Analytics for detailed memory and query execution logs (set up under Monitor > Diagnostic Settings).

2.Monitor dataset size, refresh activity, and capacity utilization, though it doesn't show live RAM usage.

3.Check query performance in Import Mode to understand memory demands.

4.Direct RAM usage monitoring is limited in Fabric; future updates may enhance telemetry.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

Hello @v-pbandela-msft ,

thanks for your help!

"4.If you need an exact size, create a temporary Import mode copy of the model, run Memory Analyzer, then discard it."

=> How can I do that? Could you explain it step by step? 

When I create a semantic model its already in direct lake mode and I cant see where I can change it

Hi @marius1106,

Thank you for reaching out in Microsoft Community Forum.

Please follow below steps to Create Import Mode Copy of a Direct Lake Model;

1.Open Power BI Desktop -- You must use Power BI Desktop to create models in Import mode (Fabric defaults to Direct Lake).

2.Connect to Fabric Warehouse - Use Get Data > Azure SQL Database, enter your warehouse server/database, and select Import when prompted.

3.Load necessary tables, then recreate any needed relationships and DAX measures.

4.Save the PBIX file, publish to Fabric if needed, run Memory Analyzer, and delete it when done.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

Check out the March 2025 Fabric update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

"); $(".slidesjs-pagination" ).prependTo(".pagination_sec"); $(".slidesjs-pagination" ).append("
"); $(".slidesjs-play.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-stop.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-pagination" ).append(""); $(".slidesjs-pagination" ).append(""); } catch(e){ } /* End: This code is added by iTalent as part of iTrack COMPL-455 */ $(".slidesjs-previous.slidesjs-navigation").attr('tabindex', '0'); $(".slidesjs-next.slidesjs-navigation").attr('tabindex', '0'); /* start: This code is added by iTalent as part of iTrack 1859082 */ $('.slidesjs-play.slidesjs-navigation').attr('id','playtitle'); $('.slidesjs-stop.slidesjs-navigation').attr('id','stoptitle'); $('.slidesjs-play.slidesjs-navigation').attr('role','tab'); $('.slidesjs-stop.slidesjs-navigation').attr('role','tab'); $('.slidesjs-play.slidesjs-navigation').attr('aria-describedby','tip1'); $('.slidesjs-stop.slidesjs-navigation').attr('aria-describedby','tip2'); /* End: This code is added by iTalent as part of iTrack 1859082 */ }); $(document).ready(function() { if($("#slides .item").length < 2 ) { /* Fixing Single Slide click issue (commented following code)*/ // $(".item").css("left","0px"); $(".item.slidesjs-slide").attr('style', 'left:0px !important'); $(".slidesjs-stop.slidesjs-navigation").trigger('click'); $(".slidesjs-previous").css("display", "none"); $(".slidesjs-next").css("display", "none"); } var items_length = $(".item.slidesjs-slide").length; $(".slidesjs-pagination-item > button").attr("aria-setsize",items_length); $(".slidesjs-next, .slidesjs-pagination-item button").attr("tabindex","-1"); $(".slidesjs-pagination-item button").attr("role", "tab"); $(".slidesjs-previous").attr("tabindex","-1"); $(".slidesjs-next").attr("aria-hidden","true"); $(".slidesjs-previous").attr("aria-hidden","true"); $(".slidesjs-next").attr("aria-label","Next"); $(".slidesjs-previous").attr("aria-label","Previous"); //$(".slidesjs-stop.slidesjs-navigation").attr("role","button"); //$(".slidesjs-play.slidesjs-navigation").attr("role","button"); $(".slidesjs-pagination").attr("role","tablist").attr("aria-busy","true"); $("li.slidesjs-pagination-item").attr("role","list"); $(".item.slidesjs-slide").attr("tabindex","-1"); $(".item.slidesjs-slide").attr("aria-label","item"); /*$(".slidesjs-stop.slidesjs-navigation").on('click', function() { var itemNumber = parseInt($('.slidesjs-pagination-item > a.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); });*/ $(".slidesjs-stop.slidesjs-navigation, .slidesjs-pagination-item > button").on('click keydown', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); var itemNumber = parseInt($('.slidesjs-pagination-item > button.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); }); $(".slidesjs-play.slidesjs-navigation").on('click', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); }); $(".slidesjs-pagination-item button").keyup(function(e){ var keyCode = e.keyCode || e.which; if (keyCode == 9) { e.preventDefault(); $(".slidesjs-stop.slidesjs-navigation").trigger('click').blur(); $("button.active").focus(); } }); $(".slidesjs-play").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-stop").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-play")) { $(".slidesjs-stop").focus(); } } }); $(".slidesjs-stop").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-play").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-stop")) { $(".slidesjs-play").focus(); } } }); $(".slidesjs-pagination-item").keydown(function(e){ switch (e.which){ case 37: //left arrow key $(".slidesjs-previous.slidesjs-navigation").trigger('click'); e.preventDefault(); break; case 39: //right arrow key $(".slidesjs-next.slidesjs-navigation").trigger('click'); e.preventDefault(); break; default: return; } $(".slidesjs-pagination-item button.active").focus(); }); }); // Start This code is added by iTalent as part of iTrack 1859082 $(document).ready(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); $("#tip2").attr("aria-hidden","true").addClass("hidden"); $(".slidesjs-stop.slidesjs-navigation, .slidesjs-play.slidesjs-navigation").attr('title', ''); $("a#playtitle").focus(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").mouseover(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").blur(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#playtitle").mouseleave(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#play").keydown(function(ev){ if (ev.which ==27) { $("#tip1").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); $("a#stoptitle").focus(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").mouseover(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").blur(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").mouseleave(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").keydown(function(ev){ if (ev.which ==27) { $("#tip2").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); }); // End This code is added by iTalent as part of iTrack 1859082