Power Bi Power query

had a power query from previous colleague, hoping a power bi expert can help me debug. its a power query to extract some data form each file and generated,