Unable to refresh the Power BI dataset due to insufficient memory

[bml123]

Hi,

I have a Power BI report with 2 GB size and I am using SQL database to create my report.  The tables I am using are huge but I am limiting the data and importing only the data that I need. I have got quite a bit of measures, calculated tables etc.

The report is loading quick inspite of huge data.

We have Power BI premium P1 capacity but unable to refresh the dataset in Power BI desktop and Power BI service due to insufficient memory. I have got 16GB RAM system and all the visuals are loading fine. It's giving this error only when refreshing dataset.

What is the maximum size that a P1 sized capacity can refresh? Any idea how to resolve this?

[pranit828]

Hi @bml123 ,
This happens sometimes when the server is over occupied.
Choosing a non work hours for couple of loads may be helpful.

Regards,

Pranit