Error on Refresh Only : Error: Expression.Error: The field 'message' of the record wasn't found..

[Ryan34747]

Hi All,

Not sure how to fix this error as it is odd: Error: Expression.Error: The field 'message' of the record wasn't found.. 
More info: Its on a PowerBI Dataflow Gen 1, Pulling in from a google sheet table. The field "message" never existed in the sheet, is not referenced by anything in the MCode not a single word is message there as this error points to it being a missing field. 

I have tried rebuilding it, putting it in a new dataflow, rebuilding it completely.. all of those things work in Power Query view.. I don't get errors in that view, only on the refresh: Error: Expression.Error: The field 'message' of the record wasn't found..

Anyone have an idea? Any help is appreciated! 

[RossEdwards]

This might be a strange fix, but can you make your last step of your Power Query be a "Remove Other Columns"?

Can you also check if you have any calculated columns that could be searching for "Message"?

[GilbertQ]

Hi @Ryan34747 

Could you make sure that there are no extra rows or columns in your Google sheet before. you finally save your data flow. There might be an extra column which is causing this error.