Your installation consumes kW, but a transformer is bought in kVA. The gap between the two is one number — the power factor — and ignoring it leads straight to undersizing.
What heats a transformer is the current through its windings — whether that current "works" or not. Two 800 kW loads don't draw the same current: at cos φ = 1 you need 800 kVA; at cos φ = 0.8 you need 1,000 kVA, and the transformer carries the current of those 1,000 kVA even though only 800 kW does work. That's why its nameplate shows kVA: a current capacity, independent of the load.
Ordering "800 kVA because we use 800 kW" would have put the transformer in permanent overload from day one.
Power electronics (drives, servers, UPS, EV chargers) distort the current: beyond cos φ, the K-factor then governs sizing. If your load is electronics-heavy, that's a separate specification — flag it in the configurator and we size for it.
General sizing guidance; the final rating depends on your installation and should be validated against your specification.