Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @Anonymous
Please check if below article could help.
https://www.sqlbi.com/articles/tuning-query-limits-for-directquery/
Regards,
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |