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

[divyehk]

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.

[GilbertQ]

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.