Forum Discussion
MP_123
10 years agoMicrosoft Employee
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 ...
birdie29
9 years agoAdvocate II
Hi Anonymous
I've just seen your comment on the OP's issue and thought this looked like a great solution, however when I try this the filters are removed when adding fields so it doesn't make any impact. The reason being is that when clicking the 'cog' you're effectively going back a step to the pre-filter view.
Am I missing something?
Thank you
Chris
AndyTrezise
8 years agoAdvocate IV
Hi
I wondered if you found a solution to your problem?
I have the same issue...i need to filter data from the SSAS cube at source as there are far too many rows to pull into PBI