OLE DB or ODBC error: Type mismatch.

Hi TylerVono ,

1. Check Data Types in Source File: The error might be occurring because you’re doing some conversion from the original data types. Go into the query editor and remove any type conversions and see if that works.
2. Remove and Re-add the Source:  Sometimes, simply removing the data source and re-adding it can resolve the issue. Go to "Home" > "Manage Queries" > "Data Source Settings", remove the source, and then reconnect to the Excel file.
3. Check for Null Values: Null values can sometimes cause type mismatch errors. Filter out or handle null values in the Query Editor.
4. Clear Data Load Cache: Try to clear the data load cache: Go to File -> Options and Settings -> Options -> Data Load -> Clear cache. Save the file and load again.
5. Update Power BI Desktop: Ensure you are using the latest version of Power BI Desktop as updates often include bug fixes.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group