Forum Discussion

Tradingpost's avatar
Tradingpost
Frequent Visitor
8 years ago

Issue with Google sheets "Column not found" during data refresh/query change application

Hi,

 

I am experiencing a weird issue with PowerBI Desktop. Everytime I try to refresh or apply the query changes in my PowerBI report which is connected to the Google sheets data, I get an error message saying "The column of the table wasn't found". All the columns in the report match the ones in the Google sheets and I have not modified the name of the columns. 

 

 

 

I would really appreciate it if someone can assist me in resolving this issue.

 

Thank you.

 

Regards,

Keerthana

Need Help

4 Replies

    • Tradingpost's avatar
      Tradingpost
      Frequent Visitor
      8 years ago

      Hi v-yulgu-msft,

       

      Thank you for your reply. The column "New Sales-cash collected ($)" was not removed from the data source, Google Sheets. In fact, this error happens only when I click "Refresh All" button. But, if I refresh each table separately, I don't face this error.

       

      Is there a way to refresh all the tables without getting that error message?

       

       

      Regards,

      Keerthana

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Tradingpost,

         

        Please uncheck the option 'Enable parallel loading of tables' (Files -> Options and Settings -> Options-> Current File, Data Load) and test again.

         

        Best regards,

        Yuliana Gu