Not for large cables and AC. Skin effect comes into play, even at 50 Hz, and in the limit R will fall as 1/D.
400 mm^2 is about as big as 3- or 4-core LV armoured gets in copper - rating around 600-700 amps in the ground I think, so about 0.5 MVA per circuit at 415 V. Three 1000 mm^2 single core cables in trefoil configuration will probably get you up to 1 MVA, if you can manage to crimp the lugs on the ends and actually connect it up, that is...