Loaded Query contained error - How to find the errors and solve the issue

Anonymous ,

In power query-> "remove rows" section, click remove errors and check if error disappeared. 

In addtion, it seems this issue should be related to data format can't be recognized by power query, I would suggest you to refer to this thread: https://community.powerbi.com/t5/Desktop/error-message-after-building-query-returns-zero-rows-in-the/td-p/159635

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.