- 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
0x80040E4E Error - OLE DB or ODBC
Hello all.
I have this strange error. I say strange because I can refresh the data on the Query Editor but I can't connect it to the model when I do "Apply". I get the 0x80040E4E error and I have literally no idea why. I just know it started occuring after I grabbed data from a folder and I created a function to get the filename in a column.
Any thoughts?
Thanks in advance!
Error
Funtion
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
After messing around with the file, I solved it. It has to do with character support, as I had cubic and degree sign on the code and it was read as "?". I changed the encoding to Western Europe and it is solved. But it was not intuitive, as the error code did not point to this. Anyway, I hope this may help someone with the same problem.
Thanks for your support.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous,
It seems that the error throws out when you apply the changes, right? In your scenario, please try to update the desktop to the version 2.42.4611.901 released in 1/20/2017.
If issue persists, please try to share the sample folder data source and sample .pbix file to reproduce the issue if possible.
Best Regards,
Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@v-qiuyu-msft i am using the latest PBI november 2020 and still getting similar error (OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.Object refrence not set to an insatance) . any idea why its still an issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
After messing around with the file, I solved it. It has to do with character support, as I had cubic and degree sign on the code and it was read as "?". I changed the encoding to Western Europe and it is solved. But it was not intuitive, as the error code did not point to this. Anyway, I hope this may help someone with the same problem.
Thanks for your support.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I know this thread is quite old, but maybe someone stumbles over this again. This error seems to have a broad spectrum of possible causes. In my case, it involved some tables being included in the incremental refresh and activating DirectQuery (Power BI Premium) to acquire the latest data. In a few DAX expressions, it broke the LOOKUPVALUE function, and it had a ripple effect on a few other tables.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks. This is what I thought happened in mine
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Como você fez para alterar a configuração dos dados ? Para Europa ocidental ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't understand this solution but have a similar problem. One of my errors is
So no mention of any column. And by the way there are no data type changes in the query editor.
Do you have any ideas how to fix? I may post this in a few places.
Thanks
Rob
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Works! I changed the data type to correctly reflect the data and it works now. Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Svalen,
Was your file a csv? I am facing the same issue with an excel file (error after grabbing data from a folder). Still nothing worked so if you have any idea?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, check your encoding in the Advanced Editor (first line I believe or by clicking source options in the next steps).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Go to Data Source Settings
Choose Global Permissions and clean any permissions not used, include anyone not used in "Data source in current file".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It did work with my error too. I changed mine to Ariel. Thank you for posting this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Which code do you refers to? This error is happening to me, can you help me please? How can I solve this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you go to the advanced editor, if your problem is similar to mine, you'll probably see some strange characters with question marks or something.
On my case, it was the name of the columns on the excel source file that was not being read properly. On the query, on the first step (Source), click on the settings button and change the encoding to Western Europe or other that works.
If you can't do this tell me, I might be able to help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just in case it helps anyone else, inside the Excel file I am importing I had a duplicated value for a field used as a 1to* relationship and that was breaking Power BI.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am having this Error, but I could refresh my data using query ,
Teh advanced editor seems to have nothing strange
Please Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I had this error as well after duplicating a table via Google Analytics connector. My issue was that I renamed the table in 'Transform Data' mode which wouldn't reflect inside the Report view and it gave me the internal error OLE .... Be careful to rename it inside transform data, rather do it after successfully added and rename it in Report mode. I've been able to rename tables it in either mode, so its a bit odd to me in this case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous
Could you provide more detail on you roslution? When I go to the query page and click the settings button, where do I go to change the encoding? I don't see an apparant way of doing this when I am connected via ODBC.
Many Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But look further, try avoiding columns with special characters and see if you can spot the issue.
Sorry I can be of more help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I updated and I still get an error, slightly different. I even copied the code to a new file and it didn't work.
I am stuck here, is there anything else I can do? How can I send you the file?
Thanks.
Error

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-30-2025 10:04 PM | |||
04-29-2020 06:17 PM | |||
07-24-2024 11:17 AM | |||
Anonymous
| 06-15-2018 03:46 PM | ||
04-15-2019 06:23 PM |
User | Count |
---|---|
136 | |
107 | |
88 | |
58 | |
46 |