Missing Data when Appending

Here it is! 

let
Source = Excel.Workbook(File.Contents("C:\Users\tescobar\Documents\LinkedIn\PowerBI Append\LSS\LSS Consolidated.xlsx"), null, true),
PowerBI_Sheet = Source{[Item="PowerBI",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(PowerBI_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"LEDGER_NAME", type text}, {"BATCH_SOURCE", type text}, {"INVOICE_DATE", type date}, {"INVOICE_NUMBER", Int64.Type}, {"INV_LINE_NUM", Int64.Type}, {"CONTRACT_NUMBER", type text}, {"CONTRACT_ORDER_NUMBER", type text}, {"SIGNED_DATE", type date}, {"BILL_TO_CUSTOMER", type text}, {"BILL_TO_CUSTOMER_ALT", type any}, {"BILL_COUNTRY", type text}, {"BILL_TO_GAM_FLAG", type any}, {"SHIP_TO_CUSTOMER", type text}, {"SHIP_TO_CUSTOMER_ALT", type any}, {"SHIP_COUNTRY", type text}, {"SHIP_TO_GAM_FLAG", type any}, {"PROD_ID", Int64.Type}, {"PRODUCT_FAMILY", type text}, {"LINE_START_DATE", type date}, {"LINE_END_DATE", type date}, {"INVOICE_CURRENCY_CODE", type text}, {"JE_LINE_DESC", type any}, {"ITEM_NUM", type text}, {"ACCOUNTING_RULE", type text}, {"BILLED_FROM", type date}, {"BILLED_TO", type date}, {"SEGMENT3", Int64.Type}, {"ACCOUNT_DESC", type text}, {"CURRENCY_CONVERSION_RATE", type number}, {"SUBSCR_PARTY_NAME", type text}, {"AGENCY_PARTY_NUMBER", type any}, {"AGENCY_PARTY_NAME", type any}, {"ORDER_TYPE", type text}, {"PAYMENT_TERMS", type text}, {"INVOICE_PAID_STATUS", type text}, {"SFDC_ORDER_TYPE", type text}, {"SFDC_CLOSE_DATE", type any}, {"BILLING_FREQ", type text}, {"BILLTO_CUSTOMER_SEGMENT", type text}, {"SHIPTO_CUSTOMER_SEGMENT", type text}, {"REGION", type text}, {"REGION_SHIPTO_COUNTRY", type text}, {"REGION_BILLTO_COUNTRY", type text}, {"AGENCY_DISCOUNT", type any}, {"INVOICE_AMOUNT", type number}, {"P2017_07", Int64.Type}, {"P2017_08", Int64.Type}, {"P2017_09", Int64.Type}, {"P2017_10", Int64.Type}, {"P2017_11", Int64.Type}, {"P2017_12", Int64.Type}, {"P2018_01", Int64.Type}, {"P2018_02", Int64.Type}, {"P2018_03", Int64.Type}, {"P2018_04", Int64.Type}, {"P2018_05", Int64.Type}, {"P2018_06", Int64.Type}, {"P2018_07", Int64.Type}, {"P2018_08", Int64.Type}, {"P2018_09", type number}, {"Total Billings", type number}, {"MFST CY/PY", type text}, {"LNKD CY/PY", type text}}),
#"Appended Query" = Table.Combine({#"Changed Type", #"LSS WF 07/17-06/18"})
in
#"Appended Query"

Thanks,

Taylor