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. Transform JSON dataset to Table
3-1. After the dataset in JSON format is loaded in the Power Query Editor, click To Table under the Transform tab.
3-2. Click OK in the pop-up window.
3-3. Click the expand icon under the Home tab to expand the column to a table.
3-4. Select all columns or selected columns, and click OK.
3-5. When the column is expanded to a table, click Close & Load.
4. View data
Your dataset should be imported and ready for use.