cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
anrema06 Regular Visitor
Regular Visitor

Errors during data loading, ERROR OLE DB or ODBC : Exception HRESULT: 0X80040E4E

Please Help, just today I am having these Errors during data loading...

 

Until yesterday the Dashboard was perfect, and today I can not refresh.... HELP¡

image.png

 

Thank you

L.R

5 REPLIES 5
vanessafvg Super Contributor
Super Contributor

Re: Errors during data loading, ERROR OLE DB or ODBC : Exception HRESULT: 0X80040E4E

@anrema06  sounds like a potential data source connection issue but the information you have provided is not enough to know the issue.  can you provide more information, what you are connecting to, how you are refreshing?  

 

check your source of the data and see if its up and running.  

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
anrema06 Regular Visitor
Regular Visitor

Re: Errors during data loading, ERROR OLE DB or ODBC : Exception HRESULT: 0X80040E4E

Well, I can refresh my data using Power Query as you can see:

Just doing modifications like order columns in Power Query editor, then Close and Apply and it Works:

 

image.pngimage.pngI checked Power Query and it works Perfect, apparently the error occurs when the data model is loaded

 

Please Help¡¡¡

vanessafvg Super Contributor
Super Contributor

Re: Errors during data loading, ERROR OLE DB or ODBC : Exception HRESULT: 0X80040E4E

@anrema06  looks like you have a data issue, click on the box that comes up it shows you what the data error is, that will take you back into power query and you should see your error rows, then look through them all to see which is failing, it is probably receiving a data type it doesn't expect.


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
anrema06 Regular Visitor
Regular Visitor

Re: Errors during data loading, ERROR OLE DB or ODBC : Exception HRESULT: 0X80040E4E

But I didnt change my data, as I said from one day to the next the errorers appeared in the load, the errors in the consultations have always been

vanessafvg Super Contributor
Super Contributor

Re: Errors during data loading, ERROR OLE DB or ODBC : Exception HRESULT: 0X80040E4E

@anrema06  powerquery doesn't load all the data it only loads a sample of the data, like the first  200 rows...  when you load into the front end thats when you load all the data,  your error message box is saying 6697 rows are a problem.  so there is a data issue in my opinion.  do you not have a new table in power query with those 6697 rows?

 

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 217 members 2,452 guests
Please welcome our newest community members: