Unable to refresh data in Semantic Model

[Devanshu]

Hello team,

Greetings for the day!

I have a subscription for the Fabric capacity of F2 (the initial capacity). I have daily data of approximately 40K, and I have built a dashboard using this data.

Today, when I tried to refresh my semantic model, I was unable to do so because it's saying that the memory is fully utilized.

Please help me with what can be done for the same.

I will also add a screenshot of the refresh error I am getting.

[audreygerred · Accepted solution]

Hello! The F2 SKU is not part of premium capacity so it needs a pro license and without premium capacity your models must remain under 1 GB. You can switch to a PPU instead (this most closely mimics an F256) or get a SKU F64 or higher. With an f64 your models can get to be 25GB, with F128 they can be 50 gb, with F256 they can be 100 gb.

[audreygerred · Accepted solution]

Hello! The F2 SKU is not part of premium capacity so it needs a pro license and without premium capacity your models must remain under 1 GB. You can switch to a PPU instead (this most closely mimics an F256) or get a SKU F64 or higher. With an f64 your models can get to be 25GB, with F128 they can be 50 gb, with F256 they can be 100 gb.

[Devanshu]

I agree with your point. Everything is currently on fabric and I do have a Pro license too. Is there any other way without reducing the data and increasing the capacity, I can work on it.

[Anonymous · Accepted solution]

Hi @Devanshu , hello audreygerred and djurecicK2 , thank you for your prompt reply!

Please see the following article for all the ways to optimise your solution at different architectural layers:

Optimization guide for Power BI - Power BI | Microsoft Learn

• The data source(s)
• The data model
• Visualizations, including dashboards, Power BI reports, and Power BI paginated reports
• The environment, including capacities, data gateways, and the networ

Best regards,

Joyce

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

[djurecicK2]

Hi @Devanshu ,

The error message is telling you what you can do. 1) reduce the amount of data or 2) increase your Fabric capacity.