Forum Discussion
filter on import data from ssas
As is, this procedure is not really correct. It's flawed yes.
You have to import and then filter out data OR as I noticed.
You can import small amount of data, filter it and then add the remaining columns or dimensions continuing to filter as you go.
It's messy, but effective.
On another note.
PBI team: Please provide pre-filters for this? :)
Anonymous
thanks!
do you mean by "table.selectRows"?
because it doesnt work for me...
1) Get data - Analysis Services
2) enter your servers name etc
3) Assuming you're importing data (not live connection): Select your timedimension and simply load it all.
4) Edit Queries and filter the year to this year for example.
5) On your right in Query settings under Applied Steps - click on the gear sign right to "Added Item" and simply add the dimensions you need and Load them each time. Filter as much as you can each time as well.
For me this works better than loading all in one which either takes way too long or doesnt work at all.
This is something that we need to be able to pre-filter before loading IMO.
Hope this helps
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
