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