Forum Discussion
CuriousGeorge
7 years agoRegular Visitor
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 th...
Anonymous
7 years agoNot applicable
CuriousGeorge Have you compared the queries that are being executed? Is Power BI sending a different query or filter context then what you are assuming is the same by manually running something in SSMS? Also, (may be unrelated, but how long ago have you updated the gateway?)
CuriousGeorge
7 years agoRegular Visitor
Haven't thought of this, will use profiler and check to see if the queries match. Thank you for the suggestion. Will let you know 😁