Forum Discussion
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!
ErrorFuntion
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.
42 Replies
I followed these steps
Step 1: Go to the Model section from the left side of the Power BI Desktop
Step 2: Delete all the relationships amongst the tables that have been created by Power BI itself while you were working with the Power Query Editor
Step 3: Click 'Refresh visual and data' option in Home (besides the Transform Data button)
It worked and loaded the new data and also applied the automations done in the query editor.
This saved me so much work, thank you!
What worked for me was file --> options -->> Data Load --> Clear Cache on all options
EDIT: Sorry I didn't see this is an old post. Hopefully helps somebody.
Yes this was my problem too. At least how it started. But it's impossible to avoid duplicate data. I am collecting data for the local council which is basically a list of dates and sites and measurements. Of course the sites and dates and measurements will have duplicates. If there is no rainfall, or a sensor is broken, it will read zero. I noticed that I had set it on some tables to filter out null values, I am a student so I didn't know, I think as a solution last time it told me duplicate values are not allowed in a one-to-one relationship, then realised today I don't want that so I removed it, and immediately got this error. I fixed it by selecting all relationships and deleting them. Also cleared cache in Power BI itself, it was over 2gb.
this worked for me,
in PowerQuery I calculate integer from datetime (example: "2023-02-07 14:08:52" = "44964")
then if i set column format in PowerBI to date i get error "0x80040E4E Error - OLE DB or ODBC"
if i set the format to whole number everything works correctlyso i guess problem is with data format...
hopefully it will help someone.
Hey there, I ended up through a naive search on the same issue. The 'Solution' post gave me the right indication. It turned out be cause by the filename of the csv files, I was collecting from a sharepoint. Renaming the files, using alphanumeric characters only, solved it for me.
v-qiuyu-msftCommunity Support
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 YuAfter 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.
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.
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
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.
I am trying to get data from Google Analytics to Power Bi but for page and page views field I am getting ' failed to save modifications to the sever . Error returned: 'OLE DB or ODBC error: [DataSource.Error] There was an internal error.. ;. Can you please help me with this issue
I had the same issue, i had duplicated a table iun power query and this issue poppedup.
It worked for me when i cleared everything in the duplicated table advanced editor and replaced the content from first table(which i duplicated from), then it worked.
Hope this helps.
