Versions Compared

Old Version 8

changes.mady.by.user Sarah Gripevall

Saved on

compared with

New Version Current

changes.mady.by.user Marcus Malmberg

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

use an access token

?

with the Connector

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