Forum Discussion

MarkPHarris1's avatar
MarkPHarris1
Icon for Helper I rankHelper I
6 years ago

Visual Has Exceeded available Resources from Powerbi Dataset Source - Solutions

Hi All,   I was just wondering if you could offer some advice. I'm currently creating reports linking to a massive Powerbi Dataset(nearly 1gb big pbix file) as a data source. When I create tables u...
Need Help
  • MarkPHarris1's avatar
    MarkPHarris1
    Icon for Helper I rankHelper I
    6 years ago

    Hi Mariusz,

     

    Thanks for getting back to me. This is the full error message we are getting if that helps:

     

    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 details: Resource Governing: The query exceeded the maximum memory allowed for queries executed in the current workload group (Requested 1048577KB, Limit 1048576KB)

     

    I had a look at the link you sent through, it is useful but I couldn't really see steps I could follow for improving the peformance. Do you have any advice?

     

    Thanks again,

     

    Mark 

     

     

    • Mariusz's avatar
      Mariusz
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Hi MarkPHarris1 

       

      I think the problem is that you are trying to display too many data points at once, as per error message.

       

      You can look at solutions like drillthrough, this technique will limit the number of records/data points you are looking at one moment and should remove the error.

      https://www.youtube.com/watch?v=2x9lLHDbtDk

       

       

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      LinkedIn

       

      • MarkPHarris1's avatar
        MarkPHarris1
        Icon for Helper I rankHelper I
        6 years ago

        Hi Mariusz,

         

        Thanks for that, we are already utilising drill through and still generate a table with 5000 rows, purely because of what our data source looks like. Do you think my suggested first changes won't help solve the issue? 

         

        Does anyone have any suggestions for not getting this error without premium or filtering in some way? Is it made slower by using a Powerbi dataset as a data source?