The Office Add-In connects to either a workspace server which can only serve tables/views and run tasks or the OLAP server which serves the cubes (which are the base for web reports). AFAIK, the linking functionality is in the WRS webapp which is not accessed by the Add-In.
I guess you just import the (raw) cube with the Add-In.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.