Forum Discussion
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Hi Muriel_A ,
The memory needs to be twice the data set, which means that the 124 data set requires 248 RAM capacity to refresh. Perhaps your capacity allocated to you is not enough RAM to refresh this doubled data set, resulting in insufficient memory.
You can upgrade it to Premium or PPU, use larger capacity and RAM, or change its connection mode to Direct Query.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Muriel_A ,
The data set stored in the pbix file is highly compressed. When it’s refreshing in Power BI service, I think I will occupy more memory space, which can possibly lead to this error.
You can try these measures:
1. Upgrade your workspace to Premium Capacity, which supports the bigger size of dataset refreshing. The Power BI Premium per user has been available till now, you can try to start a trial for free and open the premium capacity for your workspace.
2. Stagger the refresh time, try to refresh large datasets in free time, which can ensure sufficient memory space, and higher refresh efficiency.
3. Does your gateway run on the same computer? Can you guarantee the stability of the network and sufficient computer memory on the gateway computer? They are also very important.
The memory allocation problem may be solved under the premium capacity(dedicated resources and larger RAM).
More info about how to start PPU in Power BI
What’s more, the incremental refresh in Power BI can also be a good choice to avoid memory problems, which is available to Pro users. You can try if it’s possible
More info about incremental refresh in Power BI
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.