Forum Discussion

Muriel_A's avatar
Muriel_A
Regular Visitor
5 years ago
Solved

Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.

Hello,   I can't update my data on PBI service. It works on Desktop (about 9mn). I have a data set of 1 million rows. I already have simplify my queries (rows and columns deleted). Do you have an i...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.