Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I can't insert new column to visual because it causes resources exceeded error. So how to resolve the issue?
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)] )
)
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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
214 | |
84 | |
61 | |
61 | |
60 |