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 m...
Need Help
  • 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

      • Tradingpost's avatar
        Tradingpost
        Frequent Visitor
        8 years ago

        Hi v-yulgu-msft,

         

        Thank you for your response. I unchecked the box and re-tested. But now, I'm getting an error as shown in the image below.

         

         

         

        I'm not sure why I'm getting this error now...

         

        Regards,

        Keerthana