Automatic refresh fails: Exception of type System.OutOfMemoryException

[donaldo]

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.

[GilbertQ]

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?

[donaldo · Accepted solution]

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.

[GilbertQ]

Awesome, thanks for letting us know!