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