Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
Still no luck on this... Anyone have any ideas??
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |