Refreshing dataset

[waleed111]

when i try to refresh my zoho creator dataset it show me this error:

There was an error when processing the data in the dataset.

so, what is the problem?

[amitchandak]

@waleed111 , Please open edit query/Transform data mode, There should be more details on the error. Please check and share the same.

[waleed111]

i find this massage in query editor:

Expression.Error: The column 'Added Location' of the table wasn't found.

[amitchandak · Accepted solution]

@waleed111 , Check is this column (Added Location) still coming from the source or not. It may have been renamed.

You can create a new connection in a new file and check. If this has been removed or renamed. Then you can right click on the table name in edit query mode and open advance editor. In case it shows a list of the column names, you can rename or remove depending on the need.

Please keep a backup of file.