Forum Discussion
Not Enough Memory Error
Hi Kieran,
Based on my research, this error message is more related to SSAS. Please check whether you can connect to SSAS instance in SSMS or in other BI tools.
This can be caused by an incorrect memory setting in SSAS. To troubleshoot this problem, please go through this blog: SSAS error “The operation has been cancelled because there is not enough memory for the application” when there is still a lot of memory available You should make the memory settings change to give a proper value to the memory limits in either percentage of server memory, or in bytes.
Best regards,
Yuliana Gu
HI,
I have the same problem when trying to import some tables from SSAS Tabular model into Power BI.
Does anyone got the solution please ?
Thanks,
I found the resolution.
It's because of the complex MDX query that power bi is generating in the background to import the data. Using a query instead of direct import helps. I blogged about it here: https://mydataodyssey.blogspot.com/2019/03/power-bi-olap-import.html