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

[Anonymous]

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¡

Thank you

L.R

[vanessafvg]

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

[Anonymous]

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:

I checked Power Query and it works Perfect, apparently the error occurs when the data model is loaded

Please Help¡¡¡

[vanessafvg]

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

[Anonymous]

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]

@Anonymous  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?