JSON API Tutorial: Power BI
Pull your data into Power BI using JSON API
Import Data
1. Get data from web
In “Data” tab, click on “Get Data” → “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. In the Home tab, click the Expand icon to expand the column to a table.
3-4. Select all columns or customize your own selection, and click OK.
3-5. When the column is expanded to a table, click Close & Apply.
4. View the data set in a table
Click the Data tab on side navbar to view the dataset in a table.
