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 
  Url = "https://api.positiongreen.com/v1/tables/TABULATE_ID",
  Client_Id = "",
  Client_Secret = "",
  headers = [#"client_id"=Client_Id,#"client_secret"=Client_Secret,#"Content-Type"="application/json"],
  response = Web.Contents(Url, [Headers=headers]),
  Source = Json.Document(response)
in
  Source

Step 3

Populate 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.