Get VRBO reviews 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.

VRBO

VRBO covers the vacation-rental side: listing reviews, with property IDs resolvable straight from a listing URL. Here the reviews endpoint pours that text into 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. On this page it holds VRBO reviews, refreshed from one endpoint call.

The call

One endpoint returns VRBO reviews.

The VRBO Listing Reviews endpoint returns clean JSON for one listing. Send your key in the X-API-Key header. See the endpoint docs for every parameter.

GET VRBO Listing Reviews /v1/vrbo/listing/reviews/{property_id} https://api.stayapi.com/v1/vrbo/listing/reviews/19006312

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 listing id. Swap in your listing id and your API key.

query.m

let
  Source = Json.Document(
    Web.Contents(
      "https://api.stayapi.com/v1/vrbo/listing/reviews/19006312",
      [ Headers = [ #"x-api-key" = "YOUR_API_KEY" ] ]
    )
  ),
  Records = Source[data][reviews],
  Table   = Table.FromList(Records, Splitter.SplitByNothing()),
  Expanded = Table.ExpandRecordColumn(
    Table, "Column1", { "id", "rating", "rating_text", "title" }
  )
in
  Expanded

Grab your API key

50 free requests on signup, no card.

Field mapping

Response fields to columns.

Each field from the VRBO Listing Reviews response, and a suggested column name.

Response field Column

property_id property_id

total_reviews total_reviews

page page

page_size page_size

has_more has_more

sort_by sort_by

id id

rating rating

rating_text rating_text

title title

text text

reviewer_name reviewer_name

verified verified

Result

What it looks like in Power BI.

The fields from the mapping above land as columns: property_id, total_reviews, page, page_size. Refreshed on the schedule you set.

The columns you get

Every row is one listing record from the VRBO Listing Reviews response. These fields become columns:

property_id
total_reviews
page
page_size
has_more
sort_by

Keep going

More VRBO pipelines.

Other destinations

VRBO reviews to Google Sheets VRBO reviews to Looker Studio VRBO reviews to BigQuery

Build with the API

VRBO Listing Reviews endpoint docs The full VRBO API

Get your key.

01 · the fast path

Try it free

50 free requests on signup. Fastest way to see if the schema fits.

Start free

Live API key in 30 seconds
No credit card required
Same schema as paid

02 · talk to us

Talk through your pipeline

15 minutes. Volume, endpoint mix, and where the data lands. Walk out with a quote.

Book a demo

Quote on the call, not after
Engineering, not sales
No deck, no slides