Forum Discussion
Unable to refresh data in Semantic Model
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.
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.
Hi Anonymous , 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.
4 Replies
Hi Anonymous ,
The error message is telling you what you can do. 1) reduce the amount of data or 2) increase your Fabric capacity.
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.
Hi Anonymous , 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.
