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

Error on PowerBI desktop during import procedure from sql server analysis service

Hi,

on PowerBi Desktop I'm trying to import all data from Microsoft Adventure Works DWH deployed on Sql Server Analysis Service Standard Edition. If I select all measures and dimensions, during the import procedure, I receive the following error (I have enabled tracing in the Power BI desktop diagnostic area):

 

DataSource.Error: AnalysisServices: Errors in the OLAP storage engine: An error occurred while processing the dimension of the object with ID 'Fact Sales Summary 1' and the name 'Sales Summary Order Details'.
Errors in the high-level relational engine. Unable to establish a connection to the data source with the DataSourceID 'Adventure Works DW' and the name 'Adventure Works DW'.
XML for Analysis parser: Timeout of the XML for Analysis request before completion.
Details:
     DataSourceKind = AnalysisServices
     DataSourcePath = serverName; AdventureWorksDW2012

 

 

Anyway after this error If I try to apply the import I receive another error message:

"The operation has been cancelled due to insufficient memory problem. If you use 32 bit version of this product try to install 64 bit version or expand your memory on your computer"

 

PowerBI Desktop is x64 version. The size of Microsoft AdventureWorks Cube is 18 MB. I have 60 days evaluation pro account with 10 GB on cloud. I'm using a Windows 7 64-bit environment i5 with 8 GB of RAM.

 

What's the problem?

 

Thanks in advance.

 

Andrea

3 REPLIES 3
pqian Senior Member
Senior Member

Re: Error on PowerBI desktop during import procedure from sql server analysis service

@Agennaretti If you are getting all dimensions and measures, it seems like what you want is to live connect to that Cube. Can you give that a try?

Highlighted
Agennaretti Frequent Visitor
Frequent Visitor

Re: Error on PowerBI desktop during import procedure from sql server analysis service

I don't want to live connect to that cube but I want to import all (live connect is not supported because I have Sql Server Standard Edition).

 

Anyway why I receive these errors?

Moderator v-sihou-msft
Moderator

Re: Error on PowerBI desktop during import procedure from sql server analysis service

Hi @Agennaretti,

 

Currently, only Enterprise and Business Intelligence editions of SQL Server are supported for MD connectivity. Please see "Limitations of SSAS Multidimensional Models in Power BI Desktop" in below link:

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/

 

Regards,

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 185 members 1,810 guests
Please welcome our newest community members: