Forum Discussion
DirectQuery workaround maximum allowed size with Top records
Yes and no. If you look at the performance analyzer for the DAX query you will see that a TOP x limiter is included but it is pretty big, in the 500k range I think.
What you can do is add a Top N visual filter that should technically override the automatic one.
Yes it's the max limit:
// SQL Query
SELECT
TOP (1000001)
...
Adding a Top N "Filter on this visual" (table) seems to be doing something more complicated - joins to another SQL statement which is selecting Top N records by specific column, rather then just overrinding Top (1000001) and hence obeying the selected table sort order
Raise an idea at ideas.powerbi.com
I can't even do that, thanks to (excellent!) the PowerBi account restrictions/changes. Took me ages to be able to post on this forum, this is ridiculous to be honest (nothing to do with this issue apologies)
Hi, Anonymous
Have you checked this similar thread to create a mesure ,the apply it to the visual filter pane.best regards,
Community Support Team_ Eason
