Best We Hotel Power BI

Get Best We Hotel 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.

Best We Hotel Best We Hotel

Best We Hotel adds Jin Jiang's China-focused hotel catalogue, bilingual property content, guest reviews, and direct CNY room rates for teams that need stronger mainland coverage. This guide points those reviews at Power BI, refreshed on your schedule.

Power BI 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. Below you wire it to the Best We Hotel reviews endpoint in a few steps.

The call

One endpoint returns Best We Hotel reviews.

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

GET Best We Hotel Reviews /v1/bestwe/hotel/reviews https://api.stayapi.com/v1/bestwe/hotel/reviews?property_id=JJ1089
Setup

Wire Power BI to the endpoint.

  1. 01

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

  2. 02

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

  3. 03

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

  4. 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 Jin Jiang Tower Shanghai id. Swap in your hotel id and your API key.

query.m 
let
  Source = Json.Document(
    Web.Contents(
      "https://api.stayapi.com/v1/bestwe/hotel/reviews?property_id=JJ1089",
      [ Headers = [ #"x-api-key" = "YOUR_API_KEY" ] ]
    )
  ),
  Records = Source[data][reviews],
  Table   = Table.FromList(Records, Splitter.SplitByNothing()),
  Expanded = Table.ExpandRecordColumn(
    Table, "Column1", { "rating", "total", "filter", "filter_counts" }
  )
in
  Expanded
Grab your API key

50 free requests on signup, no card.

Field mapping

Response fields to columns.

Each field from the Best We Hotel Reviews response, and a suggested column name.

Response field Column
property_id property_id
rating rating
total total
filter filter
filter_counts filter_counts
tags tags
room_types room_types
id id
content content
reviewed_at reviewed_at
reviewer_name reviewer_name
room_type_name room_type_name
travel_type travel_type
helpful_count helpful_count
scores scores
hotel_responses hotel_responses
page_info page_info
Result

What it looks like in Power BI.

The fields from the mapping above land as columns: property_id, rating, total, filter. Refreshed on the schedule you set.

The columns you get

Every row is one hotel record from the Best We Hotel Reviews response. These fields become columns:

  • property_id
  • rating
  • total
  • filter
  • filter_counts
  • tags
Keep going

More Best We Hotel pipelines.

Other destinations
Best We Hotel reviews to Google Sheets Best We Hotel reviews to Looker Studio Best We Hotel reviews to BigQuery
More Best We Hotel pipelines
Best We Hotel rates to Google Sheets Best We Hotel rates to Looker Studio Best We Hotel rates to Power BI Best We Hotel rates to BigQuery
Build with the API
Best We Hotel Reviews endpoint docs The full Best We Hotel API

Get your key.

Sign up, copy your key into the snippet above, and pull live Best We Hotel reviews into Power BI.

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