Forum Discussion
Error: query1 failed to save modifications to the server error returned OLE DB or ODBC error [Expr
I am keep on getting this error in the Power BI desktop application
query1 failed to save modifications to the server error returned OLE DB or ODBC error [Expression.Error] The 'Column1' of the table wasn't found.. (see the error notification below)
When trying to "getData" . Can someone help me with that?
Thanks
6 Replies
Hi Anonymous,
Can you please share some more detail information about this issue?(e.g. desktop version, data connector, data source type and connection mode) They should help us clarify your scenario and test to troubleshoot.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
ppm1Solution Sage
That errors means that there is likely a step in your query that refrences a column by name that is no longer there. In the query editor, click on each step starting from the top and look for the first one that has the error. You can then either delete/replace that step, or modify it to remove the Column 1 reference in the Formula Bar.
Pat
Hi Anonymous,
According to your error message, I think this issue may cause with query table structure changes and data table structure not match with cached version.
AFAIK, power query will cache the data structure into the query steps and they not auto sync when data source structure changes.
For this scenario, I'd like to suggest you enter to the query editor and check the query table steps that modify the data structure(e.g. rename, change data type, reference/invoke other columns) to find out and manually fix the 'column 1' issue.
Regards,
Xiaoxin Sheng