It’s just floating-point rounding.

-- still float, but rounded back to the right integer
SELECT ROUND(POWER(9.0,28),0) AS rounded_power;

-- exact result by doing it in DECIMAL
SELECT POWER(CAST(9 AS DECIMAL(38,0)),28) AS exact_power;