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"?

[v-aatheeque]

Hi @Ryan34747 

I wanted to check back in regarding the “error as it is odd: Error: Expression.Error: The field 'message' of the record wasn't found..”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, but I haven’t heard back from you yet.

Could you let us know if you had a chance to try those steps and whether they helped resolve the issue? If you’re still experiencing problems or need additional support, please feel free to share more details we’re here to help!

If the issue has already been resolved, please consider marking the response as the accepted solution so it can assist others facing a similar challenge.

Your feedback is important, and we want to make sure you get the help you need.

Looking forward to your update!

[Ryan34747]

Nope neither item worked. 

[v-aatheeque · Accepted solution]

Hi @Ryan34747 

Thank you for bringing the issue regarding the Power BI Dataflow error to our attention. I understand that you are encountering an error related to a missing field 'message' when refreshing the dataflow, despite it not being referenced in your M code or existing in your Google Sheet.

To assist you better, I have successfully reproduced a similar scenario on my end using a sample Google Sheet, and everything is functioning as expected.

Reference : https://accessorange.com/fixing-google-sheets-and-power-bi-dataflows-the-transition-to-the-native-co...

Here are some steps you can take to troubleshoot and potentially resolve the issue :
  

• Ensure there are no hidden columns in your Google Sheet that might contain a 'message' field.
• Review your dataflow for any transformations that may reference a 'message' field.
• Confirm that the structure of your Google Sheet has not changed and headers are correct
• Ensure that any dependent dataflows or datasets are functioning correctly and not referencing a 'message' field.
• Create a simplified version of your Google Sheet with dummy data to isolate the issue.
  
  

Hope this helps !!

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

[v-aatheeque]

Hi @Ryan34747 

I wanted to follow up regarding the error you're encountering in your Power BI Dataflow Gen 1 setup:

"Error: Expression.Error: The field 'message' of the record wasn't found."

Have you had a chance to try the troubleshooting steps we previously shared? If so, we’d love to hear whether they helped resolve the issue.
If you're still experiencing problems or need further assistance, please feel free to share any additional details we are  here to help!

Your feedback is important to us, and we want to ensure you get the support you need.

Looking forward to your response.

[v-aatheeque]

Hi @Ryan34747 

I wanted to follow up on the error you’re seeing in your Power BI Dataflow Gen 1 setup:

"Error: Expression.Error: The field 'message' of the record wasn't found."

Have you had a chance to try the troubleshooting steps we shared earlier? We’d like to know if they helped resolve the issue.

If you’re still facing challenges or need more help, please feel free to share any additional details  we’re here to assist you.

Your feedback is valuable to us, and we want to make sure you get the support you need.

Looking forward to hearing back from you!

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