cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlejoSQL
New Member

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

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

1 REPLY 1

@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

Capture2.JPG


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors