This will open a wizard which asks for a URL, enter the one above (or even something else if you like): Then, from the Data menu click “From Web”: Let’s now open Microsoft Excel and use standard functionality in Power Query: Excel: Get Data… From Webįirst, you need to create a new empty spreadsheet in Excel. If you click on the link above you will see the full results, otherwise here’s a snippet: [ This API returns JSON data structure, but others may return XML, or even tabular data in CSV. Here we show how to use Power Query in Excel to retrieve data from any REST API, in this case it is some data from Wikipedia, which we have created an API in RAW as an example. Using RAW you can create your own APIs easily, but it’s likely that you will want to show users the data in their favourite data analysis tool. There’s very many datasets available through APIs now.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |