I noticed that Distinct using Azure SQL isn't fully supported as it seems to be limited to 500 or 1000 rows. Could you please extend delegation to Distinct function so it can be used with whole dataset?
Come on gents... years under review. PowerApps is used for much more than "low-code". Add some proper support of databases to work on "real datasets".