OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E

[SBC]

Hi ,

I am facing an issue when refreshing existed   table in  power query.

Error:

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E

Thanks,

SBC

[Syndicate_Admin]

When I get this error after applying changes or refreshing the input, I have generally found that in one of the input folders a PDF has been saved. So it gets processed with the excel/csv files unsucessfully.

The errors don't tell you where the issue is directly, so you have to check all the different inputs in your model to see where the problem is and then apply a filter for just the required file.

That has generally resolved the issue for me. 

[SBC · Accepted solution]

Hi,

Issue got resolve by deleting the loaded view/table  and re-imported the view/table in power query.

Thanks,

SBC

[Bikash7787]

Please delete all the connection automatically created by power BI and keep only connections that is created by you. The ln refresh the dashboard. 

[BA_Pete]

Hi @SBC ,

Please help us to help you.

How to get your question answered quickly:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2811451#M9727... 

Pete

[SBC]

Hi @BA_Pete ,

I have imported view from the  databricks source, when iam trying to make apply changes in power query, getting an error

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E

Thanks,

SBC

[v-cgao-msft]

Hi @SBC ,

Refer if these can help:

Solved: 0x80040E4E Error - OLE DB or ODBC

Data refresh error: OLE DB or ODBC error: Exceptio...

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