Forum Discussion
OLE DB or ODBC error DataFormat error HRESULT 0x80040E4E
Hello, all my tables have no errors in PowerQuery, i refreshed table by table all good, when i tried to load them into Power BI i started getting a weird error that i wasn't getting before in all the...
Hi h2bi ,
As you can see from the code reporting the error, here is my analysis of them in turn.
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E: it often relates to data type mismatches or encoding issues.
The solution is ensure that your data source’s character encoding matches the encoding expected by Power BI. Sometimes special characters (like cubic or degree signs) can cause issues. You can also clear cache or update Power BI.
Go to File > Options > Data Load > Clear Cache in Power BI Desktop
You can read this topic: Solved: 0x80040E4E Error - OLE DB or ODBC - Microsoft Fabric Community
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.