Home > Destinations > Power BI > Facebook Public Data

Connect Facebook Public Data to Power BI

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

Used by the world's leading companies

Get Facebook Public Data 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 Public Data 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 Public Data.

Connect not only your Facebook Public Data 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 Public Data data with ready-to-use dashboards for tracking performance, trends, and key indicators.

Facebook Public Data metrics and dimensions available in Power BI

Access 23 metrics and 51 dimensions from Facebook Public Data connectors including Fan Count, Follower Count, Reactions Count, Comments Count, Shares Count, Talking About Count, Page Name, Page Category, Post Created At, Post Type, Post Message, Post Permalink Url and more.

23

Available metrics

51

Available dimensions

How to connect Facebook Public Data to Power BI ?

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

Step one

Authorize Facebook Public Data

Connect Facebook Public Data in Catchr with a Facebook Public Data 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 Public Data 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 Public Data, 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 Public Data 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 Public Data 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 Public Data to Power BI?

Authorize Facebook Public Data in Catchr and enter the business Page IDs to monitor. In Catchr’s Power BI query builder, select Page Name, recent post links and available engagement counters 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 Page and post IDs, with missing fields kept distinct from zero clear in the model.

Can I analyze competitors' public Facebook Pages?

Public Page reporting can support competitor comparisons when Meta permits the application to retrieve the requested Page data. A Page being visible in a browser does not guarantee that every field is available through the API. Meta's Page Public Content Access and Page Public Metadata Access requirements govern access alongside other permissions. Test the specific Pages and fields you need before building a recurring comparison; the connection does not provide private Page insights.

What is the difference between Facebook Public Data and Facebook Pages?

Facebook Public Data focuses on available Page information and public post engagement, such as reactions, comments, and shares. It does not expose private reach, impression, audience-demographic, or conversion fields in its current catalog. Use Facebook Pages for supported insights on Pages you manage, and Facebook Ads for campaign spend and advertising outcomes. Keep those reporting scopes separate when comparing results.

Do date filters show when people reacted to Facebook posts?

The selected dates filter posts by their creation time. Reaction, comment, and share counts are the values returned for those posts when the data is retrieved, not a history of when each interaction occurred. An older post can gain engagement after the selected period and change the report. Label the chart as engagement on posts published during the period, rather than interactions received exclusively during those dates.

How do I compare post engagement without double-counting likes?

Total Reactions already includes likes, so do not add Likes Count to Reactions Count as if they were separate actions. For a simple interaction total, combine reactions, comments, and shares using consistent availability and scope. Compare that total per post alongside posting volume and publication age. These are actions, not unique people, and a rate based on current followers is not the same as engagement divided by reach.

Can I track historical Facebook Page follower growth?

Followers Count and Fan Count are current Page values, not daily histories. Followers and Page likes also describe different relationships, so use consistent fields when comparing Pages. Changing a report's date range cannot reconstruct a past follower count. Store dated snapshots separately if you need growth over time, and avoid summing a Page-level counter repeated across multiple post rows.

Why are Facebook public fields missing or different from what I see on the Page?

Check the Page ID, authorization, requested dates, and whether Meta makes the selected field available to the application. Fields can be unavailable even when the Page itself is accessible, and an unavailable value should not be treated as zero. Compare the same post by its permalink, start with a small field set, and refresh before investigating further. Public-data reporting does not guarantee a complete archive of removed, restricted, or historically unavailable posts.

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