Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

This visual has exceeded the available resources

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

Need Help

4 Replies

  • zoloturu's avatar
    zoloturu
    Icon for Memorable Member rankMemorable Member
    8 years ago

    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's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      8 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Greg_Deckler,

       

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

       

      Many thanks in advance. 

      Ronald