Dredded DISP_E_TYPEMISMATCH Error

 Have a pretty simple Excel file as the data souce. All of a sudden upon performing a refresh I encounter:

Ensured there are no errros in Power Query.

Went back to the Excel and made sure all formats match colums and cells.

Only using Number, Date, Text. 

All match up in PBI Data.

Remove all data in the source except for the hearders and 1 row and still get this error. What can I do?

Only have a few Applied Steps. 

Removed Remove Bottom Rows

Same Issue

Remove Changed Type

= Table.TransformColumnTypes(#"Promoted Headers",{{"SNO", Int64.Type}, {"Category", type text}, {"Project/ Contract Name", type text}, {"Reference Number", type text}, {"Finance Code", type text}, {"Department", type text}, {"Vendor", type text}, {"Start Date", type date}, {"End Date", type any}, {"Cost Type", type text}, {"Status", type text}, {"Total Contract Amt.", type number}, {"CAPEX 2020", type number}, {"Booked 2020 (IT)", type number}, {"Earmark 2020", type number}, {"CAPEX 2021", Int64.Type}, {"Jan", Int64.Type}, {"Feb", Int64.Type}, {"Mar", type number}, {"Apr", Int64.Type}, {"May", Int64.Type}, {"Jun", Int64.Type}, {"Jul", Int64.Type}, {"Aug", Int64.Type}, {"Sep", Int64.Type}, {"Oct", Int64.Type}, {"Nov", Int64.Type}, {"Dec", Int64.Type}, {"Q1", type number}, {"Q2", Int64.Type}, {"Q3", Int64.Type}, {"Q4", Int64.Type}, {"Comments", type text}, {"Bus. Owner", type text}})

Then I get this:

Any suggestions?