cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AadDijksman Frequent Visitor
Frequent Visitor

Importing data from SSAS into PowerBI - error not enough memory

Dear community,

 

A lot is posted about this error on which SSAS is running out of memory when trying to import data from SSAS to Power BI. But nowhere I can find a quit good explanation and a proper solution to get this fixed?

My situation:

- Server with 150GB Storage and 12GB Memory (tried 24GB also, but same result),

- SQL Server 2016 with an Analysis Service (default memory settings: 65, 80, 0),

- the to be imported tables with no relations what soever, are less than 7MB in total,

- I try to import from PowerBI (May 2019) ,

- all 64bit,

- Error: OLE DB or ODBC error: [DataSource.error] AnalysisServices: The operation has been cancelled because there is not enough memory available for the application...

 

I tried a few things like tweaking settings in SSAS, increasing memory on serverlevel, but with no results.

How come that a very small piece of data (< 7MB) can not be loaded into PowerBI? Live connection gives no problem, but is the lesser alternative in this case.

 

Thanks for thinking along with this PowerBI newbee and kind regards,

 

Aad Dijksman

1 REPLY 1
Community Support Team
Community Support Team

Re: Importing data from SSAS into PowerBI - error not enough memory

@AadDijksman ,

 

I would suggest you to create a support ticket here.

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 53 members 1,192 guests
Please welcome our newest community members: