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

[jovalle]

Hi PBI friends!

I'm receiving this error message "OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E" when trying to refresh data that I loaded into my Power BI model from Google Analytics.

Has anyone seen this Open Database Connectivity (ODBC)/Object Linking and Embeding Database (OLE DB) error message before?

Thank you so much in advance for your help! 

Best,

JP

[rohit_singh]

Hi @jovalle ,

Please open power query and navigate to the queries that are showing the error. Check each step within the query to find where the error is, and share the shareshot.

Kind regards,

Rohit

[jovalle · Accepted solution]

Hi,

I actually went in and found the error within Power Query, got ride of the error, then reloaded it and it worked!

Thanks for the call out!

Best, 

JP

[JohnTM]

Please remove this comment as a solution.  It is not a solution as it gives no indication as to what caused the problem.

[Anis_Hussain]

I am facing the same issue but there is no issue showing in the power query!

How do I resolve this, though when I click on appy changes it starts loading the row but taking long time and in between this error pops up.

[wjeanes]

Did you have any luck figuring out what was casuing your error?  I'm having the same issue, Power Query works fine but when I apply I get this error.  The data is coming from a folder containing Excel files which are then combined.  Files are identical in structure and there aren't any corrupt ones or anything like that.

[Yussufff23]

Ok sağol

[rohit_singh]

Hi @jovalle ,

That's great news. Happy to help! Please mark your answer as the solution to help others as well.

Kind regards,

Rohit