Forum Discussion

ROG's avatar
ROG
Responsive Resident
3 years ago
Solved

resources exceeded

Hi all,   Can you help me with the issue below? What can I do to have the visuals loaded? The pbix file is 3,070KB, and I have removed columns/ hidden keys, but it's still very slow still.   ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi ROG ,

     

    From your error message, it should be an overload triggered by too many visuals, resulting in too many queries.
    In this case, you need to check which visual is taking up too many resources and reduce the number of queries applied to it as much as possible.

    You can refer to this doc :

    Monitor report performance in Power BI - Power BI | Microsoft Learn

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • ROG's avatar
    ROG
    3 years ago

    Thanks Anonymous  this was exactly what I did.

    I was using two enourmous tables, and o lot os images and visuals to provide an interactive report to the business. What I did was, using a dataset which had agregated tables. It took me sometime to recreate the report, but it's now way faster.