Hi elgallego21 ,

 

Here're the solutions you could try.

 

"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. "

The above solution is from the post:

Solved: OLE DB or ODBC error: Type mismatch. (Exception fr... - Microsoft Power BI Community

 

 

And there's another similar post:

Solved: OLE DB or ODBC error DISP_E_TYPEMISMATCH - Microsoft Power BI Community

"The type mismatch is probably happening because you're doing some conversion from the orginial data types - go into the query editor and remove any type conversions and see if that works."

 

   

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.