Forum Discussion
filter on import data from ssas
hi, i have a problem that my cube is very very big so i can't import the whole data to PBI (i don't want to connect live because i want to be able to add measures, formatting and stuff) how can ...
Anonymous
thank you for your fast answer
i wanted to filter the data due to memory settings, and after i filtered its still having memory issue:
DataSource.Error: AnalysisServices: The Auto Exist operation is exceeding the permitted memory limit and is being canceled.
Details:
DataSourceKind=AnalysisServices
do you have an idea to how can i bring the data to pbi?
Do you have high number of columns ? Try to limit them as you can.
Now I'm thinking you need to write your own MDX formula for your desired query to do this.
Never received memory limitations working with cubes before myself.
I'm all out of answers really... Good luck MP_123