Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |