Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Visual has exceeded the available resources

Hi

 

I have a Overview matrix visual in my report .I am using 20 coulumsn with drill down

Drill down is like 

Country-Region-Terr-Segment-Channel-SalesRep-Fullname-Address-City-ZipCode-Actual -Target

 

Country info comes from Bridge table (powerbi security table )

SalesRep-Fullname-Address-City-ZipCode  comes from dimension table which consits of 3 million rows

Actual and Target from fact table

 

I tried to reduce as many as columns in my dimension and fact in my model

It is direct query mode and use views for the fact .Source is SQL SERVER

 

When i place the matrix drill down it started displaying visual exceeded available resources and it gets hanged

I have few more columns to bring in .

 

When i ran the Perf analyser it says 47 sec it took to complete the visual .

 

 

Need Help

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    The issue occurs when a visual has attempted to query too much data with the available resources. As a workaround, you could consider insert a slicer to dynamically filter matrix columns. For example, you could try to filter only one country and see if you can drill down to the last level.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hi 

      Thanks for your reply.I have already having a filter I(report level) and doing for only one Country .for one country itself if i drill down i am getting this issue.

      • v-lid-msft's avatar
        v-lid-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        For the issue, I cannot reproduce it here. We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

         

         

        Best regards,

        Community Support Team _ Dong Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.