Memory spike when visual's trying to load data from SSAS Cube

I have a PowerBI report on https://app.powerbi.com that's connected to a SQL Server 2016 SSAS Multidimensional cube (version 13.0.4574.0 - the latest Cumulative Update for 2016 SP1). When querying the cube from SSMS the query completes quickly without any issue and no memory spike. However, getting the same data in the power bi report on app.powerbi.com via the gateway or via the desktop app installed on the server causes the server memory to spike and drop a few times before failing with the below error message:

Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 096e0e27-c426-4dba-8e3c-2574c7ed883d
Request ID: 87ba7cdc-e718-b161-a048-6c26990d7c37
Correlation ID: 9e803dbe-fbe1-e097-8f41-4c25c021ea95
Time: Fri Jul 05 2019 14:22:00 GMT+0200 (South Africa Standard Time)
Version: 13.0.9933.240
Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net

Feedback Type:
Frown (Error)

Timestamp:
2019-07-05T12:44:15.4028779Z

Local Time:
2019-07-05T14:44:15.4028779+02:00

Session ID:
686ae25f-50da-45bd-b5f6-69c4771402a9

Release:
June 2019

Product Version:
2.70.5494.761 (19.06) (x64)

Error Message:
Server: The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.

OS Version:
Microsoft Windows NT 10.0.14393.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 460805]

Peak Virtual Memory:
34.6 GB

Private Memory:
1.08 GB

Peak Working Set:
1.24 GB

IE Version:
11.3024.14393.0

User ID:
cff4cac4-8172-49ae-bd3d-4b426081a6d0

Workbook Package Info:
1* - en-ZA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

AS Live Connection:
True

Performance Trace Logs:
C:\Users\GStevenson\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_improvedFilterExperience
PBI_qnaLiveConnect
PBI_keyDrivers
PBI_userFavoriteResourcePackagesEnabled

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:section Section1;

Memory spike on server:

There is a hard and low memory limit set on the SSAS instance on this server. The weird thing is just there's no such spike or error when getting the exact same data from the cube through SSMS.

Any ideas? 🙏