Connecting to the WildMap Database - Power Query

Getting the dataset URL

• Go to your datasets page, select the dataset that you want to view in Excel.
• Once it has opened in the top right window, click on the pen icon in the top right
• Copy the dataset URL by clicking on the Copy icon to the right of the URL field

Opening the data in Excel

• Select the Data Ribbon from the options at the top
• Click on Get Data›From other sources›From Web
• Paste the URL into the URL field and click on OK to open the Power Query Editor
• Click on the Into Table button on the Convert Ribbon
• Click on Transform in the top row, and then Pivot Column. Click on Advanced Options and then select Don’t aggregate.
• Click on OK
• Click on the up arrows in the header of the ‘table’ column, and then click on Expand to new rows
• Click on the same up arrows again, and then click on OK to make the table show all fields.
• Click on the up arrows in the header of the ‘table.properties’ field, followed by OK
• Go to the Home ribbon and click Close and Load

Connecting to the API from an Excel sheet that has been sent to you

• Click on Enable Content in the orange banner
• Select the Data Ribbon from the options at the top
• Click on Refresh all
• If you have not already entered your ACE username and password, a window will appear. Click on Basic and then enter your username and password. Click on OK. You should only need to do this once.
• The spreadsheet will now update via the API each time it is refreshed.