Import Data
1. Get data from web
In “Data” tab, click on “Get Data” → “From Other Sources” → “From Web”
2. Paste the API address in URL
3. Load table
Select the table(s) you would like to load In the Navigator pannel on the left, and click Load to load the table(s).
4. View data
Your dataset should be imported and ready for use.
Refresh Data
1. Refresh dataset
Click Refresh All under the “Data” tab to refresh the API dataset.
2. Set up auto-refresh
Click Queries & Connections under the Data tab. Right click the data table and select Properties. In Query Properties, select Refresh data when opening the file, and click OK.
