Home > Destinations > Power BI > Facebook Review

Connect Facebook Review to Power BI

Connect Facebook Review to Power BI and and make the most of your data with direct integration into Power BI. Discover how to transfer, analyze, and visualize your marketing data to support better, data-driven decisions.

Facebook Review query · Power BI format
Ready to refresh
Facebook Review One source
Saved query API URL
Power BI Web · Import
Facebook Review accounts One or several selected accounts
Reporting grain Date · campaign · ad set · ad
Fields Selected metrics + dimensions
Date range Last 28 days · example preset
Filters Optional · query-specific
Power BI mode Import through Web (Basic)
One saved URL represents one Catchr source. Multiple Facebook Review accounts can share the query.

Used by the world's leading companies

Get Facebook Review data into Power BI

A no-code connection that works in Power BI Desktop and in the Power BI service.

Connect your data

Launch Facebook Review reporting faster

Skip ODBC drivers and custom API scripts. The connection runs from your browser and Power BI, with nothing else to install on your machine.

Automate extraction

Always work with fresh numbers

Once the report is published, Power BI calls your Facebook Ads query again on the schedule you choose, so weekly reviews start from current figures.

More than just one source

Connect your entire stack. Not only Facebook Review.

Connect not only your Facebook Review account but all your Review accounts too.

Start with a template

Ready-to-use Power BI dashboards

Move faster with templates built for Review reporting in Power BI.

Use your Facebook Review data with ready-to-use dashboards for tracking performance, trends, and key indicators.

Facebook Review metrics and dimensions available in Power BI

Access 4 metrics and 23 dimensions from Facebook Review connectors including Average Rating, Review Count, Rating, Comments Count, Review Date, Recommendation Status, Reviewer Name, Review Text, Review URL and more.

4

Available metrics

23

Available dimensions

How to connect Facebook Review to Power BI ?

Four steps, from Catchr to a refreshed Power BI report.

Step one

Authorize Facebook Review

Connect Facebook Review in Catchr with a Facebook Review user that has access to the Review accounts you need, and make those accounts available for reporting.

Client A · Connected sources
5 sources ready
Facebook Review 3 advertising accounts Connected
Google Ads 2 advertising accounts Connected
Google Analytics 4 1 web property Connected
HubSpot 1 CRM portal Connected
Step two

Build and preview the query

Choose Power BI format, select Facebook Review, accounts, fields, date range, filters, and supported options. Preview the response, save the query, and copy its URL.

Step three

Use Get data > Web

In Power BI Desktop, choose Get data > Web, keep Basic selected, paste the complete Catchr URL, confirm, then load or transform the response.

Step four

Shape, model, and refresh

Clean the table in Power Query, add relationships and DAX measures, then publish the report and set its refresh schedule in the Power BI service.

Facebook Review to Power BIpricing

Choose your plan by the number of platforms and accounts you report on.

Starter

For freelancers and small teams.

$ 24 /mo

Billed monthly · cancel anytime

Platforms3
Accounts10
Start free trial

Growth

For agencies managing more clients.

$ 239 /mo

Billed monthly · cancel anytime

Platforms10
Accounts100
Start free trial

Scale

For teams reporting at scale.

$ 599 /mo

Billed monthly · cancel anytime

Platforms25
Accounts500
Start free trial

More Power BI connectors

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Facebook Review to Power BI: FAQ

Answers to common questions about connecting data to spreadsheets, dashboards, AI assistants, and reporting tools with Catchr.

How do I connect Facebook Page reviews to Power BI?

Add the review source in Catchr using the business Page identifier from its Facebook URL. Select the configured profile, app or property. Build a Power BI query with Review Date, Review Text and Recommendation Status, preview the returned reviews and import the generated URL using Get data > Web in Power BI Desktop. Set review dates and rating types in Power Query, and retain the source identifier when combining several profiles.

Are Facebook reviews and Recommendations the same thing?

Facebook uses Recommendations for feedback on business Pages, while older star-rated reviews may also appear. Catchr exposes Recommendation Status and a separate Rating field when a star rating is available. Analyze the status values actually returned; do not treat a missing star rating as zero or assign an invented star score to a recommendation. Keep legacy rating averages separate from the share of reviews recommending the business.

Why are some Facebook reviews missing from my dashboard?

Check the Page's Reviews section and whether Recommendations are enabled. Facebook states that turning Recommendations off removes the Page's visible rating and reviews. Visibility also depends on whether feedback is shared publicly and remains available on Facebook. Then check the Page identifier, review-date range, and refresh state in your report. A connector cannot recover private or removed feedback. Meta's Recommendations settings guide explains where to check.

Does this source include Facebook Ads, Page reach, or Marketplace ratings?

No. This source focuses on feedback for the configured business Page. It includes review text, dates, reviewer information, recommendation status, review links, and comment counts when available. For organic audience and content reporting, use Facebook Pages; for campaign spend and conversions, use Facebook Ads. Marketplace seller ratings are a separate Facebook feature and are not exposed by this Page-review source.

How do I measure new recommendations over time?

Group individual records by Review Date and count distinct Review IDs. Break that count down by Recommendation Status to see how the returned feedback changes over time. Use only records with a known status when calculating a recommendation percentage. The Page-level Review Count and Average Rating are current summaries, not monthly snapshots, and Catchr cannot request those global fields together with individual review fields. Keep them in separate scorecards.

Can I track replies and conversations on Facebook reviews?

Catchr exposes Comments Count and a link to the review, but its current catalog does not include comment text, the identity of the responder, or reply timestamps. A review with comments is therefore not proof that the business has answered it. Use the count to identify active discussions and open the original review to inspect or respond to the conversation. Comments Count is a current value, not the number of comments posted during your selected date range.

Can I retrieve all historical Facebook Page reviews?

One request is not an unlimited archive. Catchr follows the available review cursors until results end, the date boundary is reached, or roughly 1,000 matching reviews have been collected. Use narrower review-date windows for Pages with substantial feedback and inspect the coverage returned. The current Page review total can exceed the individual records in a dashboard. Keep each Page identifier attached to its review rows when comparing several businesses.

Still have a question?

Our team is always here to answer any questions you may have about our data connector.

Your next report should not start with five exports

Connect your marketing platforms and build a data workflow your entire agency can use.

14 days free-trial
No credit-card required
100+ sources