Forum Discussion

mpalha04's avatar
mpalha04
Helper III
8 years ago

Errors when Refreshing Google Sheets Data

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, som...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

mpalha04,

Could you please post the error message that you get?

Regards,
Lydia

mpalha04's avatar
mpalha04
Helper III
8 years ago

Here is the error message that shows when I hit Refresh

  • mpalha04's avatar
    mpalha04
    Helper III
    8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      mpalha04
      Helper III
      8 years ago

      Hi Lydia,

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Same problem here. 

         

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