Home > Destinations > Power BI > Facebook Pages

Connect Facebook Pages to Power BI

Connect Facebook Pages 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 Pages query · Power BI format
Ready to refresh
Facebook Pages One source
Saved query API URL
Power BI Web · Import
Facebook Pages 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 Pages accounts can share the query.

Used by the world's leading companies

Get Facebook Pages 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 Pages 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 Pages.

Connect not only your Facebook Pages account but all your Social accounts too.

Start with a template

Ready-to-use Power BI dashboards

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

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

Facebook Pages metrics and dimensions available in Power BI

Access 223 metrics and 178 dimensions from Facebook Pages connectors including Fan count, Page Total Action, Post Engagement Rate, Post clicks, Page post impression, Page video views click to play, Category, Website, Page address, Verification Status, Day of the month and more.

223

Available metrics

178

Available dimensions

How to connect Facebook Pages to Power BI ?

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

Step one

Authorize Facebook Pages

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

Client A · Connected sources
5 sources ready
Facebook Pages 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 Pages, 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 Pages to Power BI pricing

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 Pages 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 Pages to Power BI?

Authorize Catchr with a Facebook user who has Page insights access and grant the required Page permissions. In Catchr’s Power BI query builder, select Page activity and separate post-performance measures and preview a short extraction. Import the generated URL through Get data > Web in Power BI Desktop. Check the returned rows before building measures, keeping the business Page and the time scope of each insights metric clear in the model.

Why is my Facebook Page missing or returning a permissions error?

Check the Facebook user used to authorize Catchr, the Pages included in that authorization and the user's access to Page insights. Meta requires insights access, including the Page's Analyze task and relevant permissions. Advertising account access alone is not enough. Reconnect after changing permissions, and confirm that the expected Page appears before rebuilding charts.

Which Facebook Page metrics should I use in a new dashboard?

Start with supported Page media views, unique media viewers, follows and post interactions, then add available video and post-level metrics. Choose fields for the specific Page or post scope you need. Avoid building new charts around fields marked deprecated, and do not sum daily follower balances as though they were new followers gained during the period.

Why did my Facebook reach or impressions chart stop updating?

Meta retired several Page Insights metrics, including legacy reach, impressions and some unique video-view fields. An old field that becomes empty does not necessarily mean your audience disappeared. Replace it with the supported view-based field appropriate to the chart, such as Page Total Media View Unique or Post Total Media View Unique. Keep the definition change visible when comparing periods; a replacement metric is not automatically identical to the retired one.

Why don't post views add up to the daily Page total?

Post media views are lifetime counters for individual posts, while Page media views can describe daily activity. A post's creation date and the date someone viewed it are different. Use a post table to compare content and a Page-level time series to track daily activity. Unique viewers can overlap across posts and days, so adding those counts does not produce a deduplicated Page audience.

Can I separate paid, organic and follower views?

Catchr exposes available paid and organic media-view breakdowns and a separate follower-view breakdown. For post views, the connector does not allow follower views in the same request as paid or organic views, so use separate charts. Follower status and advertising distribution describe different things: an organic view is not necessarily a follower view, and a non-follower view is not necessarily paid.

Does Facebook Pages include advertising spend or competitor insights?

Use the Facebook Ads connector for campaign spend and attributed conversions. Private Page Insights require access to the Page; they do not unlock a competitor's private analytics. For supported public information, use the separate Facebook public data source. Label each source and metric scope clearly when showing them in one dashboard.

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