Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Import Data SSAS Memory issue

Hey everyone :) I'm trying to build my reports using SSAS and since i'm very limited with live connection i figured I would try the Import Data option. I imported my dimension tables, but I have a m...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

Power BI Desktop uses much RAM when working on it. When importing large data source with huge number of rows,  you will get the above error if the memory is not sufficient. In your scenario, please increaser your RAM and use 64 bit Power BI Desktop to import SSAS data.

In addition, it doesn’t mention any size limitations when connecting to SSAS Multidimensional Models in Power BI Desktop in this article,  however, there are other limitations, for example, servers must be running SQL Server 2012 SP1 CU4 or later versions of Analysis Services, please take a look at the “Limitations of SSAS Multidimensional Models in Power BI Desktop” part to get more details.

Thanks,
Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hey Anonymous

You mentioned above "...servers must be running SQL Server 2012 SP1 CU4 or later versions of Analysis Services...."

Where can I check If my server is running this version of Analysis Services? 

Thanks