Forum Discussion
Not Enough Memory Error
Hi,
I am using Power BI Desktop 64 Bit connecting to an Analysis Services Multi Dimensional Model via a Power Query query connection.
The fact table I am attempting to import contains less than one million rows.
My task manager says I am only using 25% of Memory / 410.0MB.
The exact error message I get is ...
DataSource.Error: AnalysisServices: Server: The operation has been cancelled because there is not enough memory available for the application. If using 32-bit version of the product, consider upgrading version or increasing the amount of memory available on the machine.
Can anyone help me here?
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
18 Replies
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 GuThank you to everyone here who has given me valuable advice.
I confirm that I am continuing my investigation with the understand that the memory issue is caused by SSAS, not Power BI.
Large Cube Takes 10+ Seconds to Parse a simple MDX query
I will of course update this thread once I reach a conclusion.
Hi Kieran,
If you have resolved your problem, please kindly mark the corresponding reply as an answer or share the valid solution so that it can benefit other users having similar problems. If you still have any question, please feel free to ask.
Best regards,
Yuliana Gu
i dont know if this will help at all but when ive been pressed for memory ive found disabling this extremely helpful, i am assuming you doing this in imported mode?
uncheck allow data preview to download in background from options / options and settings / data load
Thank you Vanessafvg,
I've added clarity to my question confirm that I am attempting to import the data. I will also uncheck the option you recommended and give it a try.
Kind Regards,
Kieran.
Kieran the other thing is though is there enough memory on the SSAS server? or it could be just one of those weird errors.. that doesn't really say what the real issue is
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.
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
hey Kieran did you got the soltion? we are getting same error
I have similar issues, but with this error and i lose all my tables and visuals on powerbi desktop. Any help
Stack Trace:
Microsoft.AnalysisServices.OperationException
at Microsoft.AnalysisServices.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
at Microsoft.AnalysisServices.XmlaClient.CheckForError(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
at Microsoft.AnalysisServices.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
at Microsoft.AnalysisServices.XmlaClient.ImageSave(String databaseId, Stream targetDbStream)
at Microsoft.AnalysisServices.Core.Server.ImageSave(ImageSaveInfo imageSaveInfo)
at Microsoft.AnalysisServices.Core.Server.ImageSave(String databaseId, Stream targetDbStream)These are some of many of the error message
