Thank you and to Durzel who answered as well.
It appears that the Model Y is different from the Model 3 in reading formatted USB (or SSD) drives.
I actually was using a SSD and when it's partitioned and formatted in FAT32 and named TESLADRIVE with folder TeslaCam and the other partion named MUSIC, the Model Y will not recognise it.
If however you format it in exFAT and repeat the above procedure, the Model Y does recognise it, and I can now see my music and the dashcam is working, and the world is a happier place.
I don't know why it's like this as I thought exFAT and FAT32 were the same, I know the Model 3 recognises FAT32.