cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 memory issue when I try to upload a view which has around 4M rows. I get this error:

 

Screenshot_1.png

 

I have installed the 64bit version. Is it because of its size that I can't upload it? And if so, is there any limitation of the size when using Import Data on SSAS.

Thanks 🙂

5 REPLIES 5
ihafidh
Regular Visitor

I was getting the same issue and after troubleshooting a bit I realized what the import was doing. When you select multiple tables, PowerBI seems to do a cross join on those tables. This leads to a huge data explosion and that is why the server runs out of memory. Try importing only one table at a time.

I had the same problem. Your comment solved my problem. Thank you!

v-yuezhe-msft
Microsoft
Microsoft

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hey @v-yuezhe-msft

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

Hi @Anonymous,

Please follow the instructions in the blog below to determine SQL Server Analysis Services version.

https://www.mssqltips.com/sqlservertip/3061/find-the-sql-server-analysis-services-and-reporting-services-version-edition-and-service-pack/

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors