
Explanation:
Box 1: Web
To use Power Query Editor to get data from a web API, you'll first need to open the editor and select "From Web". Then, paste the API URL into the provided field and choose your desired authentication method (if needed). Finally, you'll navigate the parsed JSON data in the Power Query Editor to extract and transform the information into a usable format.
Box 2: Basic
Here's a more detailed breakdown:
1. Launching Power Query and Selecting "From Web":
Open Excel or Power BI Desktop.
Go to the "Data" tab and click "Get Data".
Select "From Other Sources" and then "From Web".
2. Inputting the API URL and Authentication:
In the "From Web" dialog, paste the URL of the API you want to access.
If the API requires authentication, you'll need to choose an appropriate authentication method (e.g., Anonymous, Basic, Windows).
Reference:
https://learn.microsoft.com/en-us/power-query/connectors/web/web