resources exceeded

[ROG]

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 · Accepted solution]

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

[Anonymous · Accepted solution]

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 · Accepted solution]

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.  

[edhans]

This is likely the case of a very inefficient measure, perhaps one that is filtering a FACT table. Example:

SUMX(
   FILTER(
       Sales,
       Sales[Region] = "01"
   ),
   Sales[Amount]
)

That will perform horribly and can easily cause memory to be exceeded depending on the size of the Sales table.

CALCULATE(
    SUM(Sales[Amount]),
    Sales[Region] = "01"
)

Would perform about 100x faster with less than 1% of the memory consumption, and that isn't even the best way to do this.

But I am guessing here. You need to provide more info.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.