Preview: Direct Query to SQL REL: Query Shape limited?

[AlejoSQL]

HI all:

I am running some tests, and I find that the shape of the query is something like this:

SELECT
TOP (1000001) [t0].[ProductName] AS [c2],
COUNT_BIG([t0].[SalesKey])
 AS [a0]
FROM...

Why is the top clause included with a limitation of one million and one rows as part of the group by? . Technically, a TOP is not needed if there is no ORDER BY , no?

Thanks!

AlejoL

[Anonymous]

@AlejoSQL My initial thought is that it has something to do with the hard limits set. This screen grab is from the Power BI licensing page: https://powerbi.microsoft.com/en-us/pricing