Forum Discussion
Error on Refresh Only : Error: Expression.Error: The field 'message' of the record wasn't found..
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-connector/
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.
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!
Nope neither item worked.
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-connector/
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.
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.
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!