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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
hanygameel
Helper I
Helper I

Help in semantic model

i made calculation group using  semantic model and i made 36 caculation items the result is 
Visual has exceed available resources

hanygameel_0-1701500010759.png


when i decrease the calculation items it is working

can anyone help

 

1 ACCEPTED SOLUTION
hanygameel
Helper I
Helper I

thanks for your response and trail to solve my problem
i got it
in power bi desktop
i change the capacity from recommeded capacity to permuim capacity

hanygameel_0-1701514143442.png

and it is working now

View solution in original post

6 REPLIES 6
hanygameel
Helper I
Helper I

thanks for your response and trail to solve my problem
i got it
in power bi desktop
i change the capacity from recommeded capacity to permuim capacity

hanygameel_0-1701514143442.png

and it is working now

i think thats fine as long as you know that if you only have a pro license not premium or if you are using a shared capacity workspace then your model might have an performance issue in the service.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




vanessafvg
Super User
Super User

is this in the power bi service?   well it means that what you are doing is exceeding the capacity of what your licensing allows.    You potentially need to optimise your model.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




i make it throug power bi desktop

then check the memory of your machine in your task manager as what you are trying to do is exceeding the resources of your machine, if you are doing something memory intensive you will potentially run out of resources.   You will need to optimise what you are doing or potentially you need more memory to run power bi, as its an in-memory tool





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




i have 32 GB Ram

hanygameel_0-1701512565313.png

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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