Forum Discussion
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:
I checked Power Query and it works Perfect, apparently the error occurs when the data model is loaded
Please Help¡¡¡
Community ChampionAnonymous 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.
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?