Forum Discussion
Column (it exists) not found from google sheet connections.
This thread is solved. The OP figured out that the export format from Google changed. No issues with Power Query.
Community ChampionHello msgrewal
if Power query says that there is no such column that the probability that there is no such column is very high. Check if the column name is exactly like that. Be aware that Power Query is case sensitive. So check if the column now is calles "Execution date" or if there are some spaces like "Execution Date "
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello Jimmy and Phil PhilipTreacy
I have 5 googlesheet (all different googlesheets) connections to my Dashboard. All of them stopped working (column not found error) overnight. In all, error is on the very 1st column used in applied steps. Please note no column or base data has changed in any of those 5 googlesheets.
All other connections are working fine, except googlesheet connections.
Looks like problem is somewhere in the very first SOURCE import step.....
Refresh of SOURCE step of all googlesheets show the below, rather than standard CSV table as it has always shown. So if SOURCE step has problem, the very next applied step is not able to identify columns and throw errors
I have also re-verified all my googlesheet 'Publish to web' CSV output links. Nothing has changed literally in any of the published links.
- edhans
msgrewal a few suggestions:
First, get rid of the automatic changed type step. You can disable that in Options. It causes more problems than it solves as columns can change on import and the automatic Changed Type step will cause refresh errors.
Second, create a new connection to your source and look at the columns. I cannot see any "Execution Date" in the screenshots given that the Changed Type step is expected. Something is different, or you haven't posted the correct screenshots that shows "Execution Date" does in fact exist.
Hello Edhans,
To your point, please see screenshots below.
All data and columns exits in data and they never changed.
It doesnt matter if the Step is CHANGED TYPE or REMOVED COLUMN or any step......the very first step after source will throw column not found.
SOURCE step should look like this:
But throws error in very first step after source:
and now SOURCE step is not showing table, it shows below HTML. Although nothing in source link to googleshet changed.
As mentioned, this error is only coming in on googlesheet connections. all other connections are fine. I have 5 googlesheet connections and all of them start giving this error on refresh. Nothing has changed in any of those 5 googlesheets.
If I delete all steps and just import data at SOURCE step, this is what I get.
Not CSV as intended..