Forum Discussion
Pivot breaks SSAS query folding
Is anyone able to explain me why the following steps break my SSAS native query? let Source = AnalysisServices.Databases("xxxx", [TypedMeasureColumns=true, Implementation="2.0"]), #"SSAS Profit An...
Hi v-stephen,
it's SSAS so I cannot provide you with dummy data. However the issue is quite simple - after pivoting the native query is broken. While I can still have it done on client side, I would like the pivoting step to happen on server side. Is this possible?