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 selimovd
Thanks for the help.
It is a SQL database and I made some changes : all my queries have now 'view native query' on the last step. But it still doesn't work.
Muriel
Hello Muriel_A ,
do you get an error message?
Do you use a gateway?
One Million rows should be easily done by a relational database.
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 regardsDenisBlog: WhatTheFact.biHello selimovd , Anonymous
Yes, I till have the same error message (memory error).
I use 124 Mb / 10 Gb on my workspace, and I tried to refresh at different times, still have the same error message.
I use a gateway, but everything seems to be ok (it works with another PBI project).
It works with this method : I create my facts table in SQL Server (with all filters and transformation ...). In PBI, I load my data with a simple select * instead of a "big" query. And it works. But I think it should work with the first query....
