Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

Reply
AmiraBedh
Super User
Super User

Resources Exceeded when adding a column

‎04-26-2022 11:42 AM

I am having a report with a live connection to an SSAS Tabular model, where I am using a table visual with 28 columns

and 5 filters.

When I add other columns I encounter this error, knowing that the result of the filters is always one record :

 

 

capalt_0-1650998204767.png

capalt_1-1650998223652.png

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
Message 1 of 5
1,445 Views
0
1 ACCEPTED SOLUTION
amirabedhiafi
Impactful Individual
Impactful Individual

‎04-30-2022 08:24 AM

It happened with me, when I was using some SUM/AVG calculations.

Try to filter your data using date filters for example.

For the SSAS Tabular, partitions may help a lot to get only data needed especially when dealing with historical data.

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini

View solution in original post

Message 5 of 5
1,374 Views
4 REPLIES 4
amirabedhiafi
Impactful Individual
Impactful Individual

‎04-30-2022 08:24 AM

It happened with me, when I was using some SUM/AVG calculations.

Try to filter your data using date filters for example.

For the SSAS Tabular, partitions may help a lot to get only data needed especially when dealing with historical data.

Amira Bedhiafi
Full Stack Business Intelligence Consultant @Capgemini
Message 5 of 5
1,375 Views
Anonymous
Not applicable

‎04-29-2022 02:46 AM

Hi @AmiraBedh ,

 

Please check if this blog helps.

https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/ 

 

Best Regards,

Jay

Message 4 of 5
1,380 Views
amitchandak
Super User
Super User

‎04-26-2022 08:59 PM

@AmiraBedh , You need to simplify your table/column calculation.

 

You can increase the memory management cache(8-10GB)  along with these settings and try

 

Load Setting.png

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 2 of 5
1,400 Views
AmiraBedh
Super User
Super User
In response to amitchandak

‎04-27-2022 01:18 AM

I have the following settings and I already tried to clean the cache but the issue still persist : 

capalt_0-1651047449939.png

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
Message 3 of 5
1,397 Views
0

Helpful resources

Announcements
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All
Top Solution Authors
View All