Forum Discussion
thiagozaiden
Microsoft Employee
10 years agoFilter Analysis Services before Importing Data
Hello guys, I have a very big cube that has data from all over the world, but I only need one specific country. I could import everything and then filter it, but since its too big, I keep gettin...
- 10 years ago
Use "Advanced options" when creating your query and paste in your MDX to filter the data at the time of query.
Greg_Deckler
Community Champion
10 years agoUse "Advanced options" when creating your query and paste in your MDX to filter the data at the time of query.
- thiagozaiden10 years ago
Microsoft Employee
It worked! Thanks
- Anonymous8 years agoNot applicable
What's the MDX code to filter it?
- dkay84_PowerBI8 years ago
Microsoft Employee
You need to research mdx based in your use case and requirements. No one here is a mind reader