Get Booking.com rates into Power BI.

One endpoint call, the Power BI setup steps, and a field-to-column map. Then keep it refreshing on a schedule.

Start free with 50 requests

50 free requests on signup No credit card

Trusted by hospitality teams at

The pieces

One source, one destination.

Booking.com

Booking.com carries the largest structured review corpus in hospitality: numeric sub-scores, reviewer country, stay type, and dated text on every property. Rates and rooms sit behind the same hotel_id. Below, those nightly rates land in Power BI as sortable rows.

Power BI

Power BI talks to REST APIs natively through Power Query. No connector to install: the Web source plus one request header gets the JSON in, and scheduled refresh keeps it current. In this guide it reads Booking.com rates straight from the StayAPI endpoint.

The call

One endpoint returns Booking.com rates.

The Hotel Prices endpoint returns clean JSON for one hotel. Send your key in the X-API-Key header. See the endpoint docs for every parameter.

GET Hotel Prices /v1/booking/hotel/prices https://api.stayapi.com/v1/booking/hotel/prices?hotel_id=346648&check_in=2026-05-01&check_out=2026-05-03

Setup

Wire Power BI to the endpoint.

01

Create a StayAPI account and copy your API key from the dashboard.
02

In Power BI Desktop, choose Get Data > Web > Advanced.
03

Enter the endpoint URL and add an x-api-key request header.
04

Expand the JSON in Power Query, load it, and set a scheduled refresh in the service.

Config

Power Query: one M expression.

This uses the real endpoint URL with the example Angsana Laguna Phuket id. Swap in your hotel id and your API key.

query.m

let
  Source = Json.Document(
    Web.Contents(
      "https://api.stayapi.com/v1/booking/hotel/prices?hotel_id=346648&check_in=2026-05-01&check_out=2026-05-03",
      [ Headers = [ #"x-api-key" = "YOUR_API_KEY" ] ]
    )
  ),
  Records = Source[data][reviews],
  Table   = Table.FromList(Records, Splitter.SplitByNothing()),
  Expanded = Table.ExpandRecordColumn(
    Table, "Column1", { "block_id", "room_name", "is_refundable", "total_price" }
  )
in
  Expanded

Grab your API key

50 free requests on signup, no card.

Field mapping