Prerequisite
Create your Excel Connector in the Dstny Analytics Platform, under saved reports. Read guidelines here: Connectors. Copy the Connector link.
How to add the Connector to Excel
Select the Data tab in Excel and click the “From Web” data source.
Enter the Connector link into the Url and click Ok.
The data should appear in the Navigator and you can now select the tables you like to import into Excel.
How to load a Connector with an access token?
When loading Web data click the advanced option. Add the URL as normal and then add the header “access-token” with the access token value under the headers section.
