January 27, 2023
Hi there, I've just had an error notice in my Excel Power Query: 'The column '_submission_time' of the table wasn't found.'
I've re-downloaded the source data and the column is still there, and I can't find anywhere in my query steps where I've replaced that column name.... does anyone know what might have happened?
January 31, 2022
Go through the steps on-by-one from the Source and down. At some point the error will show up. Then look at the table in the previous step to see if that column exists. The spelling should be exactly the same and PQ is case sensitive.
If you still can't resolve it, upload some screenshots showing table just before the error occurs and the line of code in the step that produces the error. Even better if you attach the file with the source data and the query. Just make sure you don't disclose any confidential information.
January 27, 2023
Hi Riny, thanks for your reply.
I checked the column name listed in the error, and it matches the one in the manual survey download (which would make sense as I hadn't changed any wording, only added a couple of questions to the original survey). The columns in question were the metadata columns at the end of the survey, just in a later position as they’d been bumped forward. I don't know why this happened - I thought Power Query identified columns by their title, not by their order?
I managed to sort this first problem by going into the advanced query editor and deleting any reference to columns which the queries couldn’t find, as I didn't need those columns anyway. The queries loaded fine after that, but when I closed that window to get back to excel, I then got a message saying ‘trusted document settings have changed’, not all content in this file is allowed to run’. I’ve tried changing the source data and putting in the updated synchronous export link, but that hasn’t worked. Do you have any ideas on this one?
I'm tempted to just go back to the survey and take out the extra questions, but am sure PQ must be able to handle this!