Unable to use Top-N filter functionality on a Slicer

[Anonymous]

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

[v-cherch-msft]

Hi @Anonymous 

Please check if below article could help.

https://www.sqlbi.com/articles/tuning-query-limits-for-directquery/

Regards,