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 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss 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,413 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,342 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,343 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,348 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,368 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,365 Views
0

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

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