Hi All

I experienced the same error in the Desktop version, when changing the sources (excel file). The error occured due to a change in the excel file due to an update of the software that I extracted the data from. 

Error message: OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005)

The issue arised due to incorrect type of some date columns.

To fix the issue, go into Power Query Editor and right click on each column. Go to: Change Type and check what type each column is in your table.

In my case the issue arised because I had some date columns that had to be changed to the type Date. When the date columns were updated the error disappeared. 

check the formats of the Column.  First remove every step except source and try one by one. You will find which step is throwing the error.

I received this issue on a report that was fine for over a year as well, so I did what everyone said to do...

I went back all the way through a ton of steps that I had previous done, and worked, and coppied them over to one note and deleted them one by one off of PBI Query Editor. The only item left was the Source (only then was I able to refresh and get new data).  Some of these steps included these items pasted below, but the only issue that popped up when I started adding back in the steps was in the word position…  It was previously singular, and now only worked if it's typed in plural form… (Split Column by Positions)

Split Column by Positions
= Table.SplitColumn(Source, "Column1", Splitter.SplitTextByPositions({0, 7}, false), {"Column1.1", "Column1.2"})

Change Type
= Table.TransformColumnTypes(#"Split Column by Positions",{{"Column1.1", type text}, {"Column1.2", type text}})

Filtered Rows

= Table.SelectRows(#"Changed Type6", each ([Column1.1] = "  8049 " or [Column1.1] = " 19100 " or [Column1.1] = "806001 "))

Renamed Columns

= Table.RenameColumns(#"Filtered Rows",{{"Column1.1", "Job"}})

Trimmed Text

= Table.TransformColumns(#"Renamed Columns", {{"Job", Text.Trim, type text}})

Anyways, I hope this helps someone else in the futue.  PBI Novice.

IG

Upon reviewing the data, I found a mix of data types including both text and numeric values. After correcting the data types accordingly, the process proceeded without any issues.

Hi, 

I am receiving the same error with my data and cannot figure out how to fix it. 

Would it be possible to send me file to someone who can assist? I have been trying for hours. 

Thank you!

Bom dia!

Meu erro foi muito parecido com este! Fui até a base de edições do Power Query dentro do Power BI e, por mais que as minhas colunas já estivessem todas formatadas, assim como uma em específico estava como data, retirei a alteração de Tipo da coluna e re-fiz este processo. Além disto, na minha base (planilha em Excel) a formatação da coluna de data estava como texto e aconteceu algum problema ai entre a conexão da base e o PBI.

Acredito que possa ser isto, mas confira as colunas de data principalmente ou refaça todo o processo de alteração do tipo da coluna e espero que ajude!

Abraço

I recieved this error because a field type in a SQL table was changed.  PowerBI was consuming a view that contained that field, and the view retained the incorrect field type.  I scripted the view to alter it, didn't make any changes, and run the "altered" unaltered sql.  The new version of the view had the correct datatype and PowerBI digested it with no issues..

One thing to try:
Create a duplicate source of the problematic query, and load it into a new table (TEST) in the power bi dataset.  Use Dax Studio (External Tools) to identify the column type by running a query on DMV>TMSColumns.  Send output to Excel, filter for the new TEST table and original table, pivot on the table name, with the column name and explicit column type.  Made it very easy to find the mismatched column type!

OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: