Forum Discussion
Various Errors when Refreshing Google Sheets Data
I've not connected to Google sheets, but Steph Loche shows how to use R to connect here. Maybe this works better.
Same issue here.
Refresh Data doesn't work (the column 'column name' of the table wasn't found.
On the next refresh, will be another table/same error.
Case we do a manual refresh data - table by table instead of a "refresh all" - works perfectly, without this error.
Thanks
I'm having this problem too.
I don't see the option to do a table-by-table refresh. If this workd around it I'm willing to do it. Where did you find that?
You can choose which queries / tables you want to refresh by going into Query Editor and right clicking on the different tables. Just select / unselect the option for "Include in Report Refresh" as needed.
Just don't forget you have that option applied.
