Errors reported but no errors found

Hi  IanDavies,

Thanks for sharing the details. Also thanks to danextian, ajaybabuinturi, rohit1991, for those inputs on this thread.

It sounds like you're running into a confusing issue you are getting error messages during refresh, but when you go into Power Query, everything looks fine and the data is loading as expected. I can see how that would be frustrating, especially after moving the report to SharePoint.

From what you have described, this may be caused by errors that happen temporarily during refresh, but Power BI still flags them even if the data ends up loading properly. This can happen with:

• Queries that merge or join data where some rows do not match,
• Steps that silently remove errors (like "Removed Errors"),
• Or even small connection hiccups when accessing files on SharePoint.

Here are a few things you can try to resolve the issue:

1. In Power Query, check each of the queries with a warning message and expand the Applied Steps panel on the right.
2. If you see a step called "Removed Errors", try deleting it just temporarily sometimes this step hides the real error rows from view.
3. If you’re doing any merge/join steps, double-check that the keys used to match the data aren’t missing or mismatched.
4. You can also use a Power Query trick to catch any errors without stopping the refresh. This tells Power BI to continue even if something goes wrong in a specific row.
5. If everything still works and the visuals look good, the warning might just be cosmetic. You can enable Diagnostics tracing (under File > Options > Diagnostics) to dig deeper, but it’s optional.

Kindly refer to the below mentioned documentation links for better understanding:
M Language Error Handling - Power Query M | Microsoft Learn

Let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.