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
Sometimes the problem is not about RAM, it is because of complicated formula in calculated column...
check your recently added calculated column.
Hi, i'm getting the same error while trying to import a (small) SSAS tabular model to Power BI, on my VM's PBI Desktop (8 Gb RAM) and also on the VM machine with SSDT and PBI Desktop (16 Gb RAM), connected to SSAS Tabular Server machine (32 Gb RAM)
I've also tried to change the options mentioned here, in Tabular properties, and it didn't work.
What are the possible solutions for this problem? As someone has wrote, it is a strange error.
Regards
I guess it is because of a calculated column.
Try this,
Remove all of your calculated columns and then try to import the data.
I have the same problem , any one can help please ?
I have the same problem , any one can help please ?
- As I said maybe it is because of recently added calculated column. In many cases it is not because of your RAM. For test this, remove all of your calculated column and then check that!
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.
