Answer · Power BI · REST

Pinnacle odds in Power BI

Updated 10 November 2026 · PinnFeed · 1 min read

Answer: use Get Data → Web / Power Query Web.Contents with header x-api-key. Point at https://pinnfeed.io/v1/odds?.... Power BI is pull-only — not a WebSocket client.

Power Query pattern#

let
  key = Environment.GetEnvironmentVariable("PINNFEED_KEY"),
  url = "https://pinnfeed.io/v1/odds?sport=soccer&main=true&limit=50",
  raw = Web.Contents(url, [Headers=[#"x-api-key"=key]]),
  json = Json.Document(raw)
in
  json

Excel twin: Power Query answer. Store the key in a parameter or credential — never in a shared PBIX committed to git.

Trial CTA#

Builder (€99/mo) for the live + prematch WebSocket and closing history. 3-day trial; card required, charged after day 3 unless cancelled. Free delayed REST: signup. Related: answers hub, docs, pricing.

Questions people ask#

Can Power BI open the WebSocket?#

No. Use REST snapshots on a refresh schedule.

Which plan?#

Free (30 s delay, 2 sports) or Hobby for real-time REST. Builder adds WS/closing for other tools.

Is this educational content for adults?#

Yes (18+).