Excel Connector - Guide

Prerequisite

Create your Excel Connector in the Dstny Analytics Platform, under saved reports. Read guidelines here: https://meridix.atlassian.net/wiki/spaces/MS36MEN/pages/3046375425. 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 use an access token with the Connector

When loading Web data click the advanced option, add the URL as normal under “URL parts”.
Under “HTTP request header parameters, manually enter the header “access-token” followed by the actual access token.