Skip to main content
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

Post Prodigy
Post Prodigy

I can't add column to visual in Power BI



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

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! ‌‌

N V Durga Prasad


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

Here is a measure:

Filtered measure = 
    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)] )


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 :-

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 = 
    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


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.