Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Visual exceeded available resources Error both in Desktop as well as in Embed service also

Hi ,

 

I have a dataset getting data from Cosmos DB having around 5K rows only. I'm getting this issue when my dataset is reduced and power bi file, when saved with .zip extn shows about 1.4mb data size. But the complexity of DAX formulas are there, when running in Power BI Desktop , Service and in Embedded report in Web App is also having the same issue.

Also, When I run without filters my CPU and memory of the machine gets upto 90% used and after it reaches limit throws the error.

My Embedded capacity is 'A3'.

 

Is there any solution to this.

Need Help

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    7 years ago
    Hi there

    What I would suggest is having a look at your data model and ensure that it is a star schema.

    This will allow for easier DAX measures and should not exceed the resources.

    As you explained if it is taking a lot of CPU and memory I would then have a look at my data model and DAX to resolve the issue.