Forum Discussion
Anonymous
7 years agoNot applicable
Unable to use Top-N filter functionality on a Slicer
Hello,
I am trying to restrict the number of records that a slicer would retrive by using Top-N functionality but it doesn't seem to be working. I am trying to display bottom 100 PRO_NBR_TXT (Field Value) on the basis of Invoice_ID but the visual is erroring out. Just wanted to give heads-up, the field PRO_NBR_TXT has more than 10M values.
Thanks,
Jash
1 Reply
- v-cherch-msft
Microsoft Employee
Hi Anonymous
Please check if below article could help.
https://www.sqlbi.com/articles/tuning-query-limits-for-directquery/
Regards,