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

[dzehner2]

I'm getting the dreaded OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D error on a table I'm bringing in from Microsoft Project Online. I'm not sure what's causing this during a data refresh.... I'm connecting to 5 tables, and the others are coming in just fine. The table will even refresh in the Query Editor! I'm really stumped!

Here's the query:

let
Source = OData.Feed("https://nheripurdue.sharepoint.com/sites/pwa/_api/projectdata"),
Projects_table = Source{[Name="Projects",Signature="table"]}[Data],
#"Kept First Rows" = Table.FirstN(Projects_table,5000),
#"Renamed Columns" = Table.RenameColumns(#"Kept First Rows",{{"ProjectDescription", "Project Description"}})
in
#"Renamed Columns"

Any ideas on this would be super helpful! Thank you!

[v-ljerr-msft]

Hi @dzehner2,

Here is a similar thread in which some workarounds are mentioned. Could you go to check if it helps in your scenario? 

Regards

[dzehner2]

Unfortunately, I tried changing data types and removing blank rows in the table but that didn't work either. This error actually just recently started, and I haven't changed the query since I hooked it up to our Project Online system.

[dzehner2]

Still no luck on this... Anyone have any ideas??