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: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

huzefa_53

This visual has exceeded the available resources.

Submitted by Helper I on ‎05-10-2023 11:50 PM

I had publsihed a P&L report which had 14 dax in it and 3 copmany_id, Account Group , Account Dept column.
Report work fine in desktop but when published in Service it crashes and give this error.I am using PPU account. I had tried dax optimization and using group by to group data bud nothing worksin my case.
Is there any way to fix it?

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

Please try again later or contact support. If you contact support, please provide these details.

 

  • More detailsThe XML for Analysis request timed out before it was completed. Timeout value: 225 sec.
  • Activity IDd8c87ca1-336c-447b-b551-5c5f3519325b
  • Correlation ID80a5c825-9b0f-8f55-4cb6-2b6468095fd8
  • Request ID69ec3545-fbab-4808-9f00-03a980e83e35
  • TimeThu May 11 2023 11:45:19 GMT+0500 (Pakistan Standard Time)
  • Service version13.0.20626.62
  • Client version2305.1.13619-train
  • Cluster URIhttps://wabi-west-europe-d-primary-redirect.analysis.windows.net/
image.png

 

Status: Investigating

Hi @huzefa_53 

According to the documentation：

This visual has exceeded the available resources.

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.

 

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. )

4. It may also be that your local computer has insufficient content space. You can turn off the memory that is not needed in the local computer when you turn on the power bi desktop.

 

This is the related document, you can view this content:

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

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yetao1-msft
Community Support
Community Support
‎05-12-2023 12:04 AM
Status changed to: Investigating

Hi @huzefa_53 

According to the documentation：

This visual has exceeded the available resources.

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.

 

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. )

4. It may also be that your local computer has insufficient content space. You can turn off the memory that is not needed in the local computer when you turn on the power bi desktop.

 

This is the related document, you can view this content:

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

 

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses