Forum Discussion
Solved
Power BI Scheduled Refresh issue
Hello there!!! We are encountering refresh error(Memory issue) in powerbi premium capacity(p1) for one of the dataset, where other datasets are refreshing successfully. For the past couple of mon...
Hey Ganeshwar , We were having the same problem for the past 2 months.
2 things solved this for us.
1- UPDATE the on Prem gateway!
2- When you run the refresh on VM open up task manager and see how much memory it is using. Then Try to optimize the DAX queries so they are more efficent if its using a lot of memory. Not sure what the memory capacity is for Premium
If your model has not changed then the problem is most likely from the gateway not being updated. Or the Dataset is growing and consuming more memory then it did a couple of months ago
Hope this helps
Issue resolved.
A user entered a date on the absolute last row of the excel spreadsheet. Once I deleted it the refresh had no issues.
Thanks for your help.