Forum Discussion

Swathi1's avatar
Swathi1
Helper I
1 year ago
Solved

Report level visuals not loading after published.

In report level following error showig is there any alternative to fix this.

Resources Exceeded

The query has exceeded the available resources. Try filtering to decrease the amount of data requested.

Please try again later or contact support. If you contact support, please provide these details.
  • This is likely due to a problematic measure. Please see this video how to run DAX queries in DAX studio. 

     

    If you comment out all but one measure, you can enable server timings and profile each measure one at a time. You need to look to see which one is returning a large number of rows. Once you find it post here and we can advise on fixes

4 Replies

  • Deku's avatar
    Deku
    Super User

    This is likely due to a problematic measure. Please see this video how to run DAX queries in DAX studio. 

     

    If you comment out all but one measure, you can enable server timings and profile each measure one at a time. You need to look to see which one is returning a large number of rows. Once you find it post here and we can advise on fixes

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Swathi1,


    Thanks Deku for Addressing the issue.

     

    we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
    If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

     

    Regards,
    Vinay Pabbu

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Swathi1,

       

      May I ask if you have gotten this issue resolved?

      If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

       

      Regards,
      Vinay Pabbu

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi @Swathi1,

         

        we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
        If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

         

        Regards,
        Vinay Pabbu