Simple step by step for setting up API data fetching from Position Green in Power BI.

Step 1

Create a new table in Analytics -> Tabulate with the wanted data make it available for Power BI.

Step 2

Create a new Blank query in Power Bi and insert the following using Advanced editor.

let
    BaseUrl      = "https://api.positiongreen.com",
    RelativePath = "/v1/tables/" & "YOUR TABLE ID HERE",

    headers = [
        #"client_id"     = "YOUR CLIENT ID HERE",
        #"client_secret" = "YOUR CLIENT SECRET HERE",
        #"Content-Type"  = "application/json",
        #"Accept"        = "application/json"
    ],

    response = Web.Contents(
        BaseUrl,
        [
            RelativePath = RelativePath,
            Headers = headers
        ]
    ),
    Source = Json.Document(response)
in
    Source

Step 3

Generate your API credentials and insert the Client_Id and Client_Secret with the credentials provided by Position Green and replace TABULATE_ID with the wanted table id as shown below.

Hint!

You can also get a list of available TABULATE_IDs by fetching https://api.positiongreen.com/v1/tables

See /tables documentation for more information.

Want a visual tour of how to extract data to PowerBI from Position Green?

Take this guided product tour: https://app.storylane.io/share/zz1pjwm6btk7