Thanks for testing @Coffee77. Yeah, that's really strange:

• Federated queries over the same connection – work.
• Spark JDBC directly to DB – works (this does not really use the connection, but just to add more evidence for proper connectivity).

Contacted Microsoft Support.