Ok so I have tried it with out World Partition enabled and it still doesn’t work so I think it is safe to assume that its not World Partition causing issues. I saw a few comments saying that the water feature is buggy on bigger landscapes so I tired on a smaller landscape and that didn’t seem to fix the issue either.
I did find this tutorial using UE5 that has the water working at around 50mins Unreal Engine 5 Beginner Tutorial: Getting Started - YouTube I followed the same steps that he did in a new project and it still wasn’t working so…