- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E
Hi PBI friends!
I'm receiving this error message "OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E" when trying to refresh data that I loaded into my Power BI model from Google Analytics.
Has anyone seen this Open Database Connectivity (ODBC)/Object Linking and Embeding Database (OLE DB) error message before?
Thank you so much in advance for your help!
Best,
JP
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
I actually went in and found the error within Power Query, got ride of the error, then reloaded it and it worked!
Thanks for the call out!
Best,
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Here is a list that you can try:
1) Press Refresh All in Power Query Editor
2) Remove null values from your keys that you use connecting to other tables
3) Filter out errors from the table. Since Query Editor shows only 1000 line, the data error can be after that. By leaving in only error lines, you can debug this case.
4) Remove connections between tables
5) Rewrite merge commands: recreate merges you have with UI on the step just below them. Then delete them from the steps.
6) Comment out code until you succeed once, then return the code back
7) Simplify your M code: for example make merges by using SQL instead of doing it in M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi All,
I had the same issue and my solution was to refresh each table individually. Now it's working as usual.
Good luck everyone
Bruno
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello,
I come across with the error and when I refreshed my laptop network connectin (or VPN), it actually worked. This is just a simple solution.
Hope you find the answer for your query.
Thanks,
Deepak Kumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello, I, too, am experiencing this issue. The solution was discovered after a thorough investigation.
1. Create a duplicate of your working file.
2. Choose any one source --> Edit query.
3. Check any date field data type that is not automatically transformed to date.
4. Fix this. It should work.
Thanks, Karthik from India.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Has this error got resolved? I am facing similar error but don't see any sollution. Can anyone reshare the sollution here?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi.... u may try this.. before I apply/load the Power Query, I just remove connection between the data (data connector/relationship) first from the model view. When I apply it working fine, then I just manually create the connection back.
Some of them also said that we can found the error within Power Query after load, need to get rid of the error, then reloaded it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
Please open power query and navigate to the queries that are showing the error. Check each step within the query to find where the error is, and share the shareshot.
Kind regards,
Rohit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
I actually went in and found the error within Power Query, got ride of the error, then reloaded it and it worked!
Thanks for the call out!
Best,
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Please remove this comment as a solution. It is not a solution as it gives no indication as to what caused the problem.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am facing the same issue but there is no issue showing in the power query!
How do I resolve this, though when I click on appy changes it starts loading the row but taking long time and in between this error pops up.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Did you have any luck figuring out what was casuing your error? I'm having the same issue, Power Query works fine but when I apply I get this error. The data is coming from a folder containing Excel files which are then combined. Files are identical in structure and there aren't any corrupt ones or anything like that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, I don't know if this can help u guys but for mine, it works. I just delete the data connector/relationship first from the model view. When I apply it working fine, then I just manually create the connection back.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Ok sağol
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
That's great news. Happy to help! Please mark your answer as the solution to help others as well.
Kind regards,
Rohit

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-01-2024 07:00 AM | |||
04-15-2019 06:23 PM | |||
11-14-2022 09:12 AM | |||
Anonymous
| 05-10-2021 12:51 PM | ||
01-25-2018 08:44 AM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |