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

ssas import to powerbi

Hi, I'm trying to import data from a ssas cube to powerbi. Its either i get way less data than expected or i get an error saying its running on a 32 bit and i need a 64 bit. The thing is, i am on a 64 bit pbi desktop version. I've looked online everywhere but nothing seems to work. Please help. My cube is aboutt 2gb of measures and dimensions

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
d_gosbell Established Member
Established Member

Re: ssas import to powerbi

This is a generic error message, most likely coming from the ssas server. The same core engine is used across PowerPivot, Power BI and SSAS and the engine does not check if it is running in 32 or 64 bit. The problem with doing large extracts from SSAS is that the server has to materialize the entire uncompressed resultset in memory before it sends it to the client. And because you can get from 10 to 100 times compression your 2Gb model could expand to anywhere between 20-200Gb. 

 

If you can a better approach is probably to try and get access to the data source that the SSAS model is loaded from.

2 REPLIES 2
Pauwnrajpp Member
Member

Re: ssas import to powerbi

Hi Oriaikhuele,

 

Please go through the following URL.

https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/compatibility-level-for-tabula...

 

If the above URL not works, then you have to update your Power BI Desktop with 32-bit.

 

Regards,

Pradeep

Highlighted
d_gosbell Established Member
Established Member

Re: ssas import to powerbi

This is a generic error message, most likely coming from the ssas server. The same core engine is used across PowerPivot, Power BI and SSAS and the engine does not check if it is running in 32 or 64 bit. The problem with doing large extracts from SSAS is that the server has to materialize the entire uncompressed resultset in memory before it sends it to the client. And because you can get from 10 to 100 times compression your 2Gb model could expand to anywhere between 20-200Gb. 

 

If you can a better approach is probably to try and get access to the data source that the SSAS model is loaded from.