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 Championmsgrewal 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..