Error 0x80040e4e: OLE DB or ODBC [Exception from HRESULT]

Manually changing the data type of columns should help

5 min. read

Updated onJuly 23, 2024

updated onJuly 23, 2024

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Key notes

Resolve multiple Windows PC issues and speed up your PC effortlessly with specialized software.

If you are here, you have encountered the error code 0x80040e4e with the following exception OLE DB or ODBC [Exception from HRESULT] when loading or refreshing an existing table in the PowerQuery on the PowerBI desktop.

Though the message itself does vaguely not offer any insight on how to resolve it, you can easily fix the error code 0x80040e4e by implementing the solutions covered in this article.

Why do I get the 0x80040e4e error code in PowerBI?

You will encounter the error 0x80040e4e: OLE DB or ODBC [Exception from HRESULT] in PowerBI due to one of the following reasons:

How do I fix the error code 0x80040e4e in PowerBI?

1. Change the data type of the column

Generally, when a tabled gets loaded from a data source in PowerBI, the data type of the column gets detected automatically.

However, in some cases, there may be a contradiction when PowerBI applies the incorrect data type, especially for the columns with date data type causing the error 0x80040e4e: OLE DB or ODBC [Exception from HRESULT] in PowerQuery. Hence, changing the data type of the affected column should suffice.

2. Delete unnecessary relationships

The query should now load correctly without encountering the error 0x80040e4e in PowerQuery.

3. Remove duplicate columns from the table

Deleting the duplicates in multiple columns across the table will help get past the error code 0x80040e4e in PowerBI.

4. Clear the data source cache

5. Clear Global Permissions

Cleaning the global permissions will clear the login credentials forcing you to set up a fresh connection. This will help fix the 0x80040e4e: OLE DB or ODBC [Exception from HRESULT] error when you refresh the table.

That’s pretty much it! You can try the methods listed in this guide to eliminate the error 0x80040e4e : OLE DB or ODBC [Exception from HRESULT] in PowerBI.

You may also want to fix thePowerBI data source credentialsif they are greyed out for you.

Which of the tricks mentioned in this article worked in your case? We are curious to find out!

Error 0x80040e4e: OLE DB or ODBC [Exception from HRESULT]#

Why do I get the 0x80040e4e error code in PowerBI?#

How do I fix the error code 0x80040e4e in PowerBI?#

1. Change the data type of the column#

2. Delete unnecessary relationships#

3. Remove duplicate columns from the table#

4. Clear the data source cache#

5. Clear Global Permissions#