Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi,
Issue got resolve by deleting the loaded view/table and re-imported the view/table in power query.
Thanks,
SBC
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.
Hi,
Issue got resolve by deleting the loaded view/table and re-imported the view/table in power query.
Thanks,
SBC
Please delete all the connection automatically created by power BI and keep only connections that is created by you. The ln refresh the dashboard.
Hi @SBC ,
Please help us to help you.
How to get your question answered quickly:
Pete
Proud to be a Datanaut!
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
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