When using linked servers, I believe, all processing occurs on the calling server. For processing to occur on the linked server you would use OpenQuery.
Microsoft has introduced a new feature in SQL Server Management Studio (SSMS) 22 Preview 3, citing popular demand.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback