This visual has exceeded the available resources

[Anonymous]

Hi All,

I’m looking for someone who want to help me improving / optimizing some DAX measures in my model. I’m receiving this error in the service environment ‘This visual has exceeded the available resources’. But I can’t figure out which measure is causing this performance problem. I will be willing to share the PBIX file via PM.

Many thanks in advance. 

Ronald

[zoloturu]

Hi @Anonymous,

1. You can investigate memory usage by removing all except one (do it for each visual) and track RAM using Task Manager or Resource Monitor in Windows.
2. There is a tool SQL Server Profiler, which can connect to Power BI Desktop as to Analysis Services. It can show you duration and DAX query per each visual element separately.

All these options you can do by yourself.

Regards,

Ruslan

[Greg_Deckler]

There is also a great tool, DAX Studio that is free to download.

[Greg_Deckler]

I'll take a look at it, sounds interesting.

[Anonymous]

Hi @Greg_Deckler,

Did you have time to review my message? We are still experiencing the same issue.

Many thanks in advance. 

Ronald