Forum Discussion

h2bi's avatar
h2bi
Frequent Visitor
2 years ago

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 tables i am trying to load

 

Table1
    OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E
    Unexpected exception
Table2
    Not enough arguments were passed to SEARCH function. The minimum number of 
    arguments for the function is 2. OLE DB or ODBC Error: Exception from 
    HRESULT: 0x80040E4E. Unexpected exception
Table3
    OLE DB or ODBC Error: Exception from HRESULT: 0x80040E4E. Unexpected 
    exception.
Table4
    OLE DB or ODBC Error: [DataFormat.Error] Cannot convert to numeric. Unexpected 
    exception.

 

 

Table4 i have made a step with the correct formats, there is no date column in the table and the column are all in text the correct format

The Table1 is the only one with date columns which are all in date format

 

My data sources are Sharepoint and Snowflake

 

What could be the solution? i tried everything i found on forums but nothing, could this problem coming from microsoft?

Need Help
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.