API with Bearer Token Header in Power Query M

Calls a REST API that requires an Authorization: Bearer token header for authentication.

API & Web DataIntermediateapibearer tokenauthenticationweb.contents

Power Query M code

let
    Token = "YOUR_ACCESS_TOKEN",
    Source = Json.Document(Web.Contents("https://api.example.com/v1/data", [
        Headers = [Authorization = "Bearer " & Token]
    ]))
in
    Source

Tidy JSON with the JSON Formatter

Notes

Store the token as a Power Query parameter instead of hardcoding it, so it's easy to rotate without editing the query.

Requirements

An API that authenticates via a bearer token in the Authorization header.

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 API with Bearer Token Header.