ssas import to powerbi

[Anonymous]

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

[d_gosbell · Accepted solution]

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.

[Anonymous]

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