Errors when Refreshing Google Sheets Data

[mpalha04]

I have successfully connected to my Google Sheets data using the Web connector, however, when I hit the refresh button multiple errors show (table not found, etc.). Sometimes it refreshes nicely, sometimes that error message shows, but it's not completly reliable. Does anyone know how to resolve this issue to have Google Sheets data refreshed seamlessly.

Thanks

[Anonymous]

The same problem! Completely as you describe - in some cases data from sheets are updated very easy, in some cases the issue "Column not found". But nothing change. I thought that opened sheets are not updated but not :(. It is really a problem with Google sheet updating.

[andreilupan]

It seems that this issue wasn't fixed. I have exactly the same issue here. In 60-70% of the cases when the query is refreshed, an error pops up saying that "The column XYZ of the table wasn't found." When I refresh it again, a different column appears to not be found. This is not a data source issue, because all the columns are intact in the table I'm pulling the data from. And it's not a code syntax issue, because even though the Applied Steps remain exactly the same, sometimes the data is pulled correctly and sometimes it is not.

[v-yuezhe-msft]

@mpalha04,

Could you please post the error message that you get?

Regards,
Lydia

[mpalha04]

Here is the error message that shows when I hit Refresh

[v-yuezhe-msft]

@mpalha04,

The error could occur when your data source doesn't contain  the Date column any more when you click the refresh button.

Click on your query in query editor , and check APPLIED STEPS in Query Setting panel, some steps (for example,“Renamed Columns” should make changes to the Date column, as long as you remove these steps, the error should go away.


Regards,
Lydia

[mpalha04]

Hi Lydia,

I have tried removing some steps and it still doesn't seem to work...

[Anonymous]

Same problem here. 

You have to note that when you try to refresh the second time without doing anything it works. 

[mpalha04]

I should mention that nothing has changed in my table. Sometimes the data refreshes properly, sometimes I get this message.