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.
thiagozaiden
Microsoft Employee
10 years agoIt worked! Thanks
Anonymous
8 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