Problem
My scheduled refresh is throwing this error:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] OData: The property 'ABC' does not exist on type 'Alpha-Serve-Power-BI.Issues'. Make sure to only use property names that are defined by the type or mark the type as open type.
At the same time, other reports are getting refreshed perfectly.
Could you please check why it is happening? Until today, this has been working fine.
Solution
This type of issue can occur for a number of reasons. It may be that the field in question was renamed or removed from your dataset on the Power Query side, but it is still selected within the connector configuration. As a result, the attempt to refresh this column (non-existent in Power BI) leads to the error you have reported.
To fix this matter, we suggest reloading the full table and making sure that the affected field is present within it.