Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Automatic refresh fails: Exception of type System.OutOfMemoryException

Hi all,

 

I've had a setup that has worked fine for months. Now the automatic refresh from our Enterprise gateway is suddenly failing. Automatic and manual attempts fail 100% of the time with this same message. 

I have a SQL database as source and a few sheets on Sharepoint. I can't tell if this is the SQL server, our Premium capacity or what is causing this. Opening the .pbix in Power BI Desktop I can refresh fine.

 

Can anyone shed light on what is running out of memory, where? 

 

The dataset is only going to grow in size, it's currently at 83MB - so if this some kind of limit, it is a real issue.

 

Thanks in advance.

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Problem appearde to fix itself.

    I tried altering queries, turning refresh off for unecessary ones - but I don't think that was what fixed it.

     

    Now I'm back to everything working, but with the same exact setup. Temporary hiccup I guess.

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    7 years ago
    Hi there

    The error above would appear to me that you premium capacity is at its limit?

    If you could ask your Power BI Admin to have a look at the Premium metrics or the Premium Capacity Metrics App and see if it is using all the memory for other datasets, refreshes etc.

    If that is not the case then you could look at the source system and see if there are any issues there on your Gateway Server?
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Problem appearde to fix itself.

      I tried altering queries, turning refresh off for unecessary ones - but I don't think that was what fixed it.

       

      Now I'm back to everything working, but with the same exact setup. Temporary hiccup I guess.