Data format bug in the matrix

[Gabriel_Pedri]

I'm having trouble visualizing my data in a matrix in Power BI Desktop!!

I have a 5-layer drilldown and only the last two layers generate this error. Maybe it's my hardware not supporting so much data.

Another detail is that this error only occurs for daily drilldowns; it doesn't happen for months and years!

I've had problems with some visuals showing "Visual has exceeded the available resources." I don't know if it's because of my hardware or if Power BI has a query limitation.

I've tried modifying the data format, returning different values to confirm if it's the visualization or the value/measure, but nothing seems to fix this.

Could someone help me with this?

Thank you very much for your attention in advance.

[Anonymous]

Hi, @Gabriel_Pedri 

Thanks @Uzi2019 . You can place the mouse on the edge of the table visual to adjust the column width of each column so that the data can be displayed normally. I tried to create a scene that shows the same as you, as shown in the image below:

Place your mouse in the red box in the image below and adjust it to the right so that the value is fully displayed:

The results of the adjustment are as follows:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Uzi2019]

Hi @Gabriel_Pedri 

According to the error message provided on the image, it states, "This visual object has exceeded available resources. Try filtering to reduce the amount of data displayed. " The cause of this problem may be the dataset may be too large or complex for a Power BI Pro license.The error may be related to the recent Power BI update in November.

I think you can simplify the query by removing unnecessary columns, filters or transformations that consume too much memory. Reducing the amount of data is also necessary. I think you can reduce memory usage in Power BI by using Power BI Premium and if the dataset is very large, use DirectQuery or Live Connection to query the data directly from the source. If you are using Power BI Premium, request the Capacity Manager to increase the memory limit per query. You can also take a more in-depth look at the document below: how to fix visual has exceeded the available resource. - Microsoft Q&A

I hope I answered your question!

[Gabriel_Pedri]

When you mention limitation per query, are you referring to Power BI Desktop or Power BI Service?

Because it wouldn't make sense to limit my own hardware, but rather if it were in the cloud.

[Uzi2019]

Hi @Gabriel_Pedri 
limitation per query per visual. for every visual there is limitation.

[Gabriel_Pedri]

Thank you very much for the response regarding the log 'Visual has exceeded the available resources.'

However, I need help with the formatting error in the matrix shown in the image.