"Visual Has Exceeded the Available Resources" While Displaying Top 10 Records in Power BI

[Nithinbob24]

I’m facing a recurring issue in my Power BI reports where I need to display the top 10 records based on a measure. However, I frequently encounter the error message: "Visual has exceeded the available resources."

Here’s what I’ve tried so far:
1.Applying the default "Top N" filter in Power BI.

2.Using the following DAX measures:

• rank_amt = RANK(Skip, ALLSELECTED(table1[mem_id]), OrderBy([amt_sum], DESC, table1[mem_id], DESC))
• rank_amt2 = RANKX(ALLSELECTED(table[mem_id]), [amt_sum], , DESC, table[mem_id], ASC)
• topn_meas = TOPN(10, table, [amt_sum], DESC, table[mem_id], DESC)

None of these approaches resolved the issue; the error persists in all cases.

What alternative solutions or optimizations can I apply to display the top 10 records in a resource-efficient manner? Any help is appreciated.

[v-yaningy-msft]

Hi,  @Nithinbob24 
Thanks for danextian and Ritaf1983‘s reply, you can try their dax. Generally, the issue occurs when a visual has attempted to query too much data for the server to complete the result with the available resources.

As suggested in the error, you may need to try filtering the visual to reduce the amount of data in the result currently. there is limit. Apply data-point limits and strategies by visual type 

And you can follow the tips to optimize your report：

1.Do not expose in a view a column that is not necessary in the Power BI data model.

2.Optimize the DAX calculation used in this visual to use less memory and return faster or change what the visual displays.

3.Remove unnecessary precision or split granularity values to reduce cardinality(Significantly reduce highly unique datetime values by splitting the date and time into separate columns. )

This is the related document, you can view this content:

The “Visual Has Exceeded The Available Resources” Error In Power BI

Visual has exceeded the available resources - Table Visual

Error: Resource Governing - Microsoft Power BI Community

resources exceeded - Microsoft Power BI Community

only Premium capacity can increase the per-query memory limit, you can refer to these articles if you need:  What is Power BI Premium?  How to purchase Power BI Premium

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

View solution in original post

[danextian]

Hi @Nithinbob24 

Try this:

top products =
VAR _topn =
    SELECTCOLUMNS (
        TOPN (
            10,
            ADDCOLUMNS (
                SUMMARIZE ( ALLSELECTED ( table1[mem_id] ), table1[mem_id] ),
                "@amt", [amt_sum]
            ),
             "@amt"], DESC
        ),
        [mem_id]
    )
RETURN
    CALCULATE ( [amt_sum], KEEPFILTERS ( table1[mem_id] IN _topn ) )

If this sitll doesn't work then there may be other reasons involved like number of columsn in the viz and other measures.

[Ritaf1983]

Hi @Nithinbob24 
Do you use a direct query method for importing the data?

[Nithinbob24]

Hello, I am importing the data from SQL server