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.

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Muriel_A ,

 

what is your data source?

Try to use a relational database and check if query folding is working (does the last step show "view native query"):
Query folding | Microsoft Docs

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis