Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
So lets say I have a dataset with 10,000 values. These values are simply 1-10,000
I load batches with 100 values at a time. When I call sort on my custom table by ascending, I get 100, 99, 98 etc. But what I really want is for the sort to query the database, and return the values 10,000, 9999, 9998 etc.
Is this possible? I want to avoid using the filter pane if possible. I noticed that the original tables make a querydata call when sorting values. How can I replicate this?