Forum Discussion

Gabriel_Pedri's avatar
Gabriel_Pedri
Resolver I
2 years ago

Data format bug in the matrix

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.

Need Help
Tutorial Requests

5 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    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's avatar
      Gabriel_Pedri
      Resolver I
      2 years ago

      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.

    • Gabriel_Pedri's avatar
      Gabriel_Pedri
      Resolver I
      2 years ago

      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's avatar
        Uzi2019
        Community Champion
        2 years ago

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

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.