Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DirectQuery workaround maximum allowed size with Top records

Hi,   using SQL Server Direct Query   I have a standard fact table visualised as 'Table' and dimension tables as 'Slicers'   the fact table has 100 mil records, so depending on the filters, the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

lbendlin's avatar
lbendlin
Super User
5 years ago

Raise an idea at ideas.powerbi.com

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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)