Real-space observation of magnetic transitions in RMn6Sn6 (R = Ho, Dy) kagome magnets