Forum Discussion

Ganeshwar's avatar
Ganeshwar
Frequent Visitor
4 years ago
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...
Need Help
  • PBIandME's avatar
    PBIandME
    4 years ago

    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

Nick555's avatar
Nick555
Helper I
3 years ago

We are having some similar issues.  I'm confused for a few reasons.
     1. The dataset iscurrently less than 1,000 records. 
     2. The problem just started this week. On Monday and today. Prior to this it has been running with no issues for the past 3 months or so.
     3. If I manually refresh it it works.
    4. It's currently set to refresh at 3 am local time so there shouldn't be any users entering new data.
So did the suggested fix above resolve the issue or is there sonmething else I'm overlooking?
Thanks