Dredded DISP_E_TYPEMISMATCH Error

[Anonymous]

 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?

[Anonymous]

I went ahead and deleted most of the Applied Steps:

Source - Didn't delete

Navigation - Didn't delete

Promoted Headers - Deleted

Changed Type - Deleted

Removed Bottom Rows - Deleted 

Once I deleted Promoted Headers the refresh went though without any error. Although now all my visiuals had errors. I then went back in to Transform Data and selected "Use first row as headers", and everything came back. I have the original data in teh soriuce file so no clue what caused all of this...??

[Anonymous]

Hi @Anonymous ,

The type mismatch error is probably happening while you're doing some conversion for the data in tables.

Looks like this column does not meet the conditions of the conversion type.

Best Regards,

Jay

[amitchandak]

@Anonymous , Please check your start date, there are some dates, which are not getting converted to date has some format issue

[Anonymous]

No, that's not it. I've removed all the dates in the Start Date Column in the source file and still get the error.