Trustpilot reviews to Power BI

Through an OData v4 feed that Reviewflowz publishes. You create a connection in Reviewflowz and copy its feed URL, then in Power BI choose Get data, OData feed, and paste it. Authenticate with the token as the user name and a blank password. The navigator lists the tables and you load the ones you want. There is nothing to install: OData is a format Power BI has read for years, so its built-in connector does the work.

Six: Reviews, ReviewProfiles, Locations, RatingsHistory, ReviewSummary and ReviewChanges. Reviews is one row per Trustpilot review with the rating, the review date, the title, the full text, the reviewer name, the location, the language, the tags and the link. RatingsHistory and ReviewSummary give you the rating over time without computing it yourself, and ReviewChanges is the stream of inserts, updates and deletes.

Yes. Power BI’s scheduled refresh pulls from the feed on whatever cadence you set. Incremental refresh works too, because the review date is a datetimeoffset the feed can filter on, which is exactly what Power Query folds a RangeStart and RangeEnd window into. The first load brings your Trustpilot history, then the dataset pulls the window.

It arrives as a delete row in ReviewChanges, with a timestamp. That is the difference between a change stream and a snapshot: a review that gets flagged and taken down is an event in your model rather than a row that silently stops appearing. Edits come through the same way, so a one-star raised to four after you fixed the problem is visible as a change.

Yes, and it is the reason to do this at all. The reviews land as a table in your own semantic model, so you relate them to your date table and your region dimension like anything else. One-stars per thousand orders is then a DIVIDE across two tables you already have. Reviewflowz does not supply the orders: they are yours, already in the model.

Yes. The model is yours, so your existing RLS roles apply to the review tables the same way they apply to everything else. Separately, the feed token carries the access of the Reviewflowz user who created it, so someone restricted to a subset of profiles cannot mint a token that exposes the rest.

The BI feed is a Premium feature and it is not part of the free trial, so budget for that rather than discovering it on day three. Everything else works the way the trial suggests: you connect your Trustpilot profile yourself and see your reviews in minutes.

No. You connect your Trustpilot profile and create the BI connection yourself, in under five minutes. If you get stuck, support is the people who build it.