How to Identify Errors in Power Query
It's looks very simple to load the data into Power Query and do the transformation. In case your query contains error. It might affect the report you are trying to publish or data you are trying to extract.
This is just to give you overview on How to identify the error in Power Query. You can drill down as per your data and analyse the gap in data.