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
My SSAS settings are fine. Set to 90% on a 32 GB server machine. Still get the same error.
I have only a couple of calculated columns, but I have lot of visualizations and measures dependent on them. Does that mean, everytime I have to add new columns to the query from the source or refresh the dataset in Desktop, I need to delete all the data prep steps and re-do them?
Anyways, it doesn't work either. Get the same error even after removing all the calculated columns and other data prep steps.
This is very weird. How much memory does Importing from SSAS need? Doesn't make sense. Both Live connection and full process of model on SSAS server work fine.