Forum Discussion
OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005)
Hi rocky09 ,
I had a similar report set up on the Power BI Service that failed to refresh but provided me with a more detailed error. It turns out one of the fields contains string values when the ODBC connection was expecting date. When I checked the set up for the original data source the field in question was shown as a string so I'm not sure where the change occured.
Luckily, in this instance, I think I'll be able to omit the field from the report as I don't think it's entirely necessary. Hopefully that will negate the issue.
Thanks,MarkJames
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