I suggested Fit Y by X because it does have an option to specify a Block column, which is a potential way to handle your repeat measures. The only conditions for Fit Y by X is the blocks have to be balanced and you can only have 1 treatment factor. If you're dead set on using REML, I don't know how to get the full ANOVA table from Fit Model with random effects. I don't think you can.
I guess you could work it out backwards by hand. The Fixed Effects test will give you the F-ratio and the numerator and denominator degrees of freedom. The MSE is in the variance components table. First, we need to solve for the treatment mean squares (let's call it MSM), and the total mean squares (MST).
To get MSM, multiply the F-ratio by MSE. Now, add MSM and MSE together to get MST.
Now, all that's left to do is multiply each of those by their respective degrees of freedom to get SSM and SST. SSM = MSM*DF (numerator degrees of freedom). SST = MST*(DF + DFDen).
To my understanding, computing the effect size from this approach makes it relative to the total variance remaining after accounting for random effects. If you want to calculate it relative to the total variance including random effects, you could compute SST on your response variable column with a column formula like Col Sum((:Y - Col Mean(:Y))^2).
-- Cameron Willden