The Isle of Wight Council has been told it must make urgent and fundamental changes after being warned that government intervention could follow if things do not improve quickly.