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

I will have to see if I can find an IT guy to answer that. 

What I do know is that the data source is an excel spreadsheet stored on sharepoint online. The columns have not changed but new records are entered during the week. 
Once I find out from IT I'll let you know.

Thanks!

  • PBIandME's avatar
    PBIandME
    Advocate I
    3 years ago

    Also plese check how long manual refresh takes, and how much memory it consumes.