Forum Discussion

chrislau3636's avatar
chrislau3636
Frequent Visitor
8 years ago

PowerBI web - visual has exceeded available resources

I have create a PowerBI dashboard with  11 visualizations charts, sometimes one or more chart will have error:

 

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.

 

The XML for Analysis request timed out before it was completed. Timeout value: 225 sec.

Activity ID57a2a773-d5c8-6bda-8e97-5b51f300257d

Correlation ID120c9859-da9e-abda-13c7-1c36586fd134

Request ID2bcc6d63-6b40-3285-40ad-6f456f0013bb

TimeMon May 14 2018 14:57:12 GMT+0800 (China Standard Time)

Version13.0.5248.195

Cluster URI https://wabi-south-east-asia-redirect.analysis.windows.net

 

Is it any limitation of PowerBI or need some settings in SQL server or others? the records count is about 80000 and use direct query mode. Please help, thanks.

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi chrislau3636,

     

    As you mentioned, the error occurs when a visual attempts to query too much data for the server to complete the result with the available resources.  You may need to filter the visual to reduce the amount of data in the result currently. That way, the error might be resolved.

     

    Regards,

    Yuliana Gu

    • Cfarinha's avatar
      Cfarinha
      Frequent Visitor
      8 years ago

      Repeating the error message is not helpful and frankly annoying. I don't want to filter my visuals to reduce the amount of data. My own junky hard-drive has no problem processing the stuff I am making. Why can't the web service?

    • chrislau3636's avatar
      chrislau3636
      Frequent Visitor
      8 years ago

      Hi v-yulgu-msft

       

      I have see the the DirectQuery mode can support no less that 1 million rows (Our database only have 100000 rows). What is the limit with the available resources? Please advise, thanks.

       

      Regards,

      Chris Lau 

    • denR's avatar
      denR
      Icon for Advocate I rankAdvocate I
      8 years ago

      Hi v-yulgu-msft,

       

      Could you elaborate a little bit on what the resources are? So if we would like to query this amount of data, should we upgrade the server on which SSAS is running, should we upgrade the computer on which Power BI Desktop is used or all computers that interact with reports via Power BI Service?