Forum Discussion
Solved
Various Errors when Refreshing Google Sheets Data
Hey Everyone, I have a report that draws in data from a Google Sheet (using the web connector method), and when I refresh, I'll often get a variety of error messages, despite the preview loading ...
I've not connected to Google sheets, but Steph Loche shows how to use R to connect here. Maybe this works better.
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.