OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E

[Anonymous]

Hi,

I've read all the posts on fixing this error, and none of them seem to apply to me.  I have a data source, from which I've split into 3 different queries of Completed, Approved and In Progress depending on the status of the data. I've then created a 2 further queries that work out the average time it takes the business to complete a Quick Win for the current month, and a seperate one for completing a Project in the current month. From this, I've created another query that depicts last month's time taken to complete Quick Wins and again another one for Projects completed last month. Then in a further 2 queries, subtracted this months data from last months to find out if we are completing them quicker or longer than last month. I'm not sure if the amount or level of links are contributing to this error? 

[amitchandak]

@Anonymous , Open Edit Query/Transform Data mode and check there will some detailed error. Share that.

if needed

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

[Anonymous]

Do you mean just like this, or do you mean in the Advanced editor? There are no errors in any of the queries

[v-jingzhang]

Hi @Anonymous , has this problem been solved? If not yet, could you test whether it can be refreshed successfully if only refreshing this table? You could right click on other tables and uncheck Include in report refresh to test refreshing it singly.

Additionally, here is a possible cause for this error:

https://social.technet.microsoft.com/Forums/en-US/7eb55134-40b8-4c70-afe5-d7cb68ae29b4/pol-query-source-error-for-some-users-0x80040e4e?forum=powerquery