Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Analitika
Post Prodigy
Post Prodigy

I can't add column to visual in Power BI

Hi,

 

I can't insert new column to visual because it causes resources exceeded error. So how to resolve the issue?

4 REPLIES 4
nvprasad
Solution Sage
Solution Sage

Hi Analitika,

 

Assuming you are trying to add new column to either Matrix or Table which is having complex calculations or more number of rows.

If that is the case it may lead to this issue.( atleast which i seen before).

it quite literally means there are not enough resources by the Power BI’s server to display the visual you have selected.

 

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad

 

So maybe possible to optimize some measures which are already in table visual?

Here is a measure:

Filtered measure = 
SUMX (
    FILTER (
        VALUES ('N08-Klientai'[N08_PAV] ),
        [20_2_1_DATA PRADELSIMAS] <= 30 && [20_2_1_DATA PRADELSIMAS] >=1
    ),
    CALCULATE ( [18_1_0_BENDRA SKOLA (nuo istorijos pradzios)] )
)

 

pratyashasamal
Super User
Super User

Hi @Analitika ,

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.

You can refer to this blog for more info :-
https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Could you tell me how I could optimize this measure, maybe possible somehow?

 

Filtered measure = 
SUMX (
    FILTER (
        VALUES ('N08-Klientai'[N08_PAV] ),
        [20_2_1_DATA PRADELSIMAS] <= 30 && [20_2_1_DATA PRADELSIMAS] >=1
    ),
    CALCULATE ( [18_1_0_BENDRA SKOLA (nuo istorijos pradzios)] )
)

Here is measure. 

20_2_1_DATA PRADELSIMAS is measure and 
18_1_0_BENDRA SKOLA (nuo istorijos pradzios is measure.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.