let
    源 = Sql.Database("l\l1", "test", 
    [CommandTimeout=#duration(0,1,0,0),ConnectionTimeout=#duration(0,1,0,0)]),
    all= 源{[Schema="dbo",Item="One_M_TY"]}[Data],
    r=if (TopRow)>=0 then Table.FirstN(all,TopRow) else all
in
    r

let


     all = Sql.Database("l\l1", 
            "test", [Query="select * from [dbo].[Sheet1] "
             //[Query="select "&TopRow&"* from [dbo].[Sheet1] "
            ,CommandTimeout=#duration(0,1,0,0)])
in
    all

=================================================

vs直接设置