DirectQuery mode not supported

[sqlpirate]

Here's my query, I get an error "Not supported in DirectQuery mode":

 let
Source = Sql.Database("***.database.windows.net,1433", "sqldb"),
dbo_departure = Source{[Schema="dbo",Item="departure"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(dbo_departure,{"ident"}),
#"Sorted Rows" = Table.Sort(#"Removed Other Columns",{{"ident", Order.Ascending}}),
list = Table.ToList(#"Sorted Rows")
in
list

Can someone tell me which part of this is not supported in DirectQuery mode? The error message doesn't give me much to go on. 

[v-huizhn-msft · Accepted solution]

Hi @sqlpirate,

The ‘list = Table.ToList(#"Sorted Rows")’ statement is not supported in Direct Query Mode. As I tested, it works fine and get desired result when I run the following query.

let Source = Sql.Database("CNV-HUIZHN-W10", "AdventureWorks2014"), 
HumanResources_vEmployeeDepartmentHistory = Source{[Schema="HumanResources",Item="vEmployeeDepartmentHistory"]}[Data],
 #"Removed Other Columns" = Table.SelectColumns(HumanResources_vEmployeeDepartmentHistory,{"GroupName"}), 
#"Sorted Rows" = Table.Sort(#"Removed Other Columns",{{"GroupName", Order.Ascending}})
in #"Sorted Rows"

While it return error when I add the ‘list = Table.ToList(#"Sorted Rows")’ in quey.



Best Regards,
Angelia

Best Regards,
Angelia