cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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!

 

ErrorErrorFuntionFuntion

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@v-qiuyu-msft

 

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.

View solution in original post

26 REPLIES 26
darrenfishell
Helper II
Helper II

I'm pulling from a Dataflow and getting this same error and the same vaguely helpful error message. 

Would be excellent if the error identified the fields in question.

Whatever is going wrong here is also not being caught by Table.RemoveRowsWithErrors() either.

darrenfishell_0-1654700946282.png

 

divsforeal
Frequent Visitor

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.

arunava93ghosh
New Member

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 worked for us as well. In addition to the OLE ODBC error we were getting a note about not being able to find data sources we had deleted months ago and were not mentioned anywhere in the model. Thanks!

This saved me so much work, thank you!

Brilliant! This worked for me. 😅

Thank you!! 

dufu
Regular Visitor

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.

Anonymous
Not applicable

I solved this issue ,Re-install Oracle Client 

 

Anonymous
Not applicable

Hi,
I came across a similar problem but its source was duplicate data on a column that created a relationship with a different table. Even worse, he didn't appear on the table causing the error.

arslaan29
Frequent Visitor

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

v-qiuyu-msft
Community Support
Community 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 Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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.

Anonymous
Not applicable

@v-qiuyu-msft

 

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.

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? 

Hi, check your encoding in the Advanced Editor (first line I believe or by clicking source options in the next steps). 

Go to Data Source Settings

Choose Global Permissions and clean any permissions not used, include anyone not used in "Data source in current file".

 

image.png

It did work with my error too. I changed mine to Ariel. Thank you for posting this.

Which code do you refers to? This error is happening to me, can you help me please? How can I solve this?

Anonymous
Not applicable

@Gabrielna12

 

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.

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors