let
    Source = Excel.Workbook(File.Contents("C:\Users\devanshi\OneDrive\Documents\Analytics\Power BI\Superstore Dataset.xls"), null, true),
    Orders1 = Source{[Name="Orders"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Orders1, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Row ID", Int64.Type}, {"Order ID", type text}, {"Order Date", type date}, {"Ship Date", type date}, {"Ship Mode", type text}, {"Customer ID", type text}, {"Customer Name", type text}, {"Segment", type text}, {"Country", type text}, {"City", type text}, {"State", type text}, {"Postal Code", Int64.Type}, {"Region", type text}, {"Product ID", type text}, {"Category", type text}, {"Sub-Category", type text}, {"Product Name", type text}, {"Sales", type number}, {"Quantity", Int64.Type}, {"Discount", type number}, {"Profit", type number}}),
    #"Removed Duplicates" = Table.Distinct(#"Changed Type", {"Order ID"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Duplicates", each true)
in
    #"Filtered Rows"