High severityschema
Power BI Refresh Error:
HRESULT: 0x80040E37
What does this error mean?
The Analysis Services or OLE DB provider cannot find the specified table or object. The hex code 0x80040E37 maps to the OLE DB error DB_E_NOTABLE — object does not exist.
Common causes
- 1A table referenced in a partition query or relationship was dropped or renamed in the source database
- 2The dataset connects to an SSAS cube and a dimension or measure group was removed from the cube
- 3A calculated table in the Power BI model references a source table that no longer exists
- 4The database or schema prefix in the query changed (e.g., 'dbo.Orders' renamed to 'sales.Orders')
- 5The Power BI model was published targeting a different database than the one that has the table
How to fix it
- 1Note the object name in the error message and verify it still exists in the source database
- 2In Power BI Desktop, open the Query Editor and find the step that references the missing table
- 3Update the table reference to the new name/schema and publish the updated dataset
- 4If using SSAS, open SSMS and browse the cube structure to verify dimension and measure group names
- 5Check whether the Power BI Service dataset was published against the correct server and database (dev vs. prod)