Retrieve Data from a REST API in Power Query M

Calls a JSON REST API and converts the response into a table.

API & Web DataAdvancedapiwebjsonrest

Power Query M code

let
    Source = Json.Document(Web.Contents("https://api.example.com/v1/sales", [Headers = [Authorization = "Bearer YOUR_TOKEN"]])),
    ConvertedToTable = Table.FromRecords(Source[data])
in
    ConvertedToTable

Tidy JSON with the JSON Formatter

Notes

Replace the URL and Authorization header with your API's actual details, and Source[data] with the field name that holds the array of records in the response.

Requirements

An API endpoint that returns JSON, and any required auth token.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Retrieve Data from a REST API.