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

SSAS / Power BI

I have an SSAS server that experiences massive memory usage when I connect PBI desktop to it to try to publish a report.  I don't experience this issue with our clunky, old, on-premise server.  I am using the same gateway to access both servers.  Why would the beefier Prod server have memory issues only when interrrogating using PBI?  When I emulate the query using the SQL browser, I don;t get the memory drain problem.

5 REPLIES 5
Community Support Team
Community Support Team

Re: SSAS / Power BI

Hi BrianMiller,

 

You said " I am using the same gateway to access both servers. ", so you are connecting to ssas in import mode, right? Power bi has some limitation about your data size, you can refer to this answer: https://www.quora.com/Can-I-import-a-10-GB-data-set-into-Power-BI.

 

Regards,

Jimmy Tao

BrianMiller Frequent Visitor
Frequent Visitor

Re: SSAS / Power BI

I am not connecting in import mode.  I am using the on-premise gateway to connect directly to SSAS db.

Community Support Team
Community Support Team

Re: SSAS / Power BI

Hi BrianMiller,

 

So this issue happens in power bi service, right? The data size limitation in power bi service is same with that in power bi desktop.

 

Regards,

Jimmy Tao

BrianMiller Frequent Visitor
Frequent Visitor

Re: SSAS / Power BI

Hi Jimmy,

 

I don't think there is any limitation whatsoever since I am reading the data directly from an SSAS dtabase in real-time, NOT importing the data.  Besides, the entire cube is tiny, less than 1 GB. 

Highlighted
BrianMiller Frequent Visitor
Frequent Visitor

Re: SSAS / Power BI

Also, the report renders just fine when using a different server.