Power Query Sort Returns Nulls

[SHC]

Hi,

I'm running a power query on a table of data. However, when I apply a sort, Power Query returns a table of Nulls. Any ideas why, please, and how to fix this?

My code is:

let
    Source = Excel.CurrentWorkbook(){[Name="Opp_SF_Export"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Opportunity ID", type text}, {"Close Date", type datetime}, {"Account ID", type text}, {"Owner ID", type text}, {"Created Date", type datetime}, {"Name", type text}, {"Opportunity Type", type text}, {"Probability (%)", Int64.Type}, {"IsCreatedFromLead", type logical}}),
    #"Sorted Rows" = Table.Sort(#"Changed Type",{{"Created Date", Order.Ascending}, {"IsCreatedFromLead", Order.Descending}, {"Probability (%)", Order.Descending}})
in
    #"Sorted Rows"

Thanks.

 

[Chihiro]

Do you have Data Model and Load to Worksheet co-existing in same workbook? This can cause issue.

Can you upload sample data? It'll make it easier to trouble shoot your issue.