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

Visual exceeded available resources error in Power BI

Hello,

 

I am getting this error after publishing Power BI report in pbi service, server. How to resolve that issue?

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

Hi, @Analitika 

 

Try filtering the visual to reduce the amount of data in the result.

This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.

Your visual has attempted to query too much data for us to complete the result with the available resources. Try filtering the visual to reduce the amount of data in the result.

refer:

This visual has exceeded the available resources.

 

And you can follow the tips to optimize your report:

1.Do not expose in a view a column that is not necessary in the Power BI data model.

2.Optimize the DAX calculation used in this visual to use less memory and return faster or change what the visual displays.

3.Remove unnecessary precision or split granularity values to reduce cardinality(Significantly reduce highly unique datetime values by splitting the date and time into separate columns. 

 

refer:

The “Visual Has Exceeded The Available Resources” Error In Power BI

Visual has exceeded the available resources - Table Visual

Data Import Best Practices in Power BI

 

 

Hope this helps.

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

3 REPLIES 3
v-angzheng-msft
Community Support
Community Support

Hi, @Analitika 

 

Try filtering the visual to reduce the amount of data in the result.

This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.

Your visual has attempted to query too much data for us to complete the result with the available resources. Try filtering the visual to reduce the amount of data in the result.

refer:

This visual has exceeded the available resources.

 

And you can follow the tips to optimize your report:

1.Do not expose in a view a column that is not necessary in the Power BI data model.

2.Optimize the DAX calculation used in this visual to use less memory and return faster or change what the visual displays.

3.Remove unnecessary precision or split granularity values to reduce cardinality(Significantly reduce highly unique datetime values by splitting the date and time into separate columns. 

 

refer:

The “Visual Has Exceeded The Available Resources” Error In Power BI

Visual has exceeded the available resources - Table Visual

Data Import Best Practices in Power BI

 

 

Hope this helps.

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

GilbertQ
Super User
Super User

Hi @Analitika 

 

This typically means that either the DAX measure is not well written and is using too much memory/CPU to complete the computation.

 

I would suggest making sure you are using a star schema in your dataset. 

And then that your DAX measure is written as efficiently as possible?





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

Proud to be a Super User!







Power BI Blog

I am also getting this error.

 

My model has 24 tables. 

  • 6 tables come from the Adventure Works database (Excel and CSV files), 
  • 5 PDF files (50 US states & zip codes over the 5 files),
  • 3 PDF files (about 30 rows total over the 3 files), 
  • 1 SQL Table with 2K rows and about 60 columns
  • 4 other PDF/HTML tables with a total of about 1300 rows over the 4 tables.
  • 1 Calendar table (used the CALENDARAUTO Function) with about 86K rows and 15 columns.

There is only 1 report page which I use just for displaying tables and card visuals.

This model is used strictly as a model for teaching PBI.

When I add 13 columns of the Calendar table to a table visual, all is fine.  When I try to add the 14th column, I get the error.  This table is the only visual.
My PBIX file is less than 4Mb.
Is there a way to determine which available resources I am exceeding?




Helpful resources

Announcements
Europe Fabric Conference

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.

PBI_Carousel_NL_June

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.

Top Solution Authors