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
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