> David's comment seems to imply that this is fine [...]
No, I'm fairly sure David was saying the opposite: ditch the local PSU and just use the 24V from the MS. I also agree that is the best approach, and the one I have used myself.
My point was if you absolutely must use a different PSU, it will need to share a common ground with the MS as otherwise there is no circuit. To explain it another way, the DI cannot (reliably) sense a +24V "potential difference" without having visibility of the ground that it is expected to measure that "difference" from.
(The ill advised hack is to connect both PSU commons to the domestic earth, but this could be dangerous and can be unreliable and you're creating headaches for whoever has to maintain it in future, so far better to put a dedicated shared ground between the PSUs.)
Either way, you should also check with the PSU manuals: some might not like having the 0V terminal tied down to another reference voltage like this.
In summary, I agree with David: using the MS 24V is unequivocally better.