Forum Discussion
Solved
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries
Hi, I have a reasonably large report that is failing to refresh regularly. However I am still able to refresh the desktop app. From my reading, it seems that the likely cause is some Dax I a...
Hi, this did fix the memory issue, but slowed things down to unusable level on the refresh. I upgraged the work space and it sorted the issue out
Hi Taz_Car
What I would suggest doing, is to create the table in Power Query, this will mean that the table will not need to be created using the memory but it will be part of the import process.
By using Power Query the table will also be made a lot smaller due to being compressed on the way from Power Query to the Power BI dataset.
Thanks, I will try and let you know if it works.