Direct Query Limit
Limits the number of rows when using the DirectQuery mode. This helps avoid performance issues at design time.
Limits the number of rows returned when using the DirectQuery Mode. This limit only applies when aggregation is not being used. Queries with SUM, MIN, MAX, GROUP BY, and so on will not be limited.