How to get data from 3rd party REST API in PowerBI?

Hi gooduling,

I think you can choose a web connector to handle the rest API.

Solved: Pull data from a REST API Authentication - Microsoft Power BI Community

Sample formula:

let
    token = "",
    Result =
        Web.Contents(
            "https://xxxxx.xxx.com",
            [
                Headers = [
                    #"Content-Type" = "application/json",
                    Authorization = "Bearer " + token,
                    RelativePath = "/api/items"
                ]
            ]
        )
in
    Result

Regards,

Xiaoxin Sheng