Home > Destinations > Power BI > Instagram Public Data

Connect Instagram Public Data to Power BI

Connect Instagram 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.

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

Used by the world's leading companies

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

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

Instagram Public Data metrics and dimensions available in Power BI

Access 5 metrics and 30 dimensions from Instagram Public Data connectors including Profile Followers, Profile Follows, Profile Post Count, Media Likes, Comments, Username, Name, Post Type, Post Caption, Post Hashtags, Link To Post, Post Created, Date and more.

5

Available metrics

30

Available dimensions

How to connect Instagram Public Data to Power BI ?

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

Step one

Authorize Instagram Public Data

Connect Instagram Public Data in Catchr with a Instagram 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
Instagram 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 Instagram 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.

Instagram Public Data 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.

Instagram 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 Instagram Public Data to Power BI?

Authorize the Facebook connection with access to a Page linked to an Instagram Business or Creator account and enter the target usernames in Catchr. In Catchr’s Power BI query builder, select username, publication links and available public 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 profile and publication identifiers, without treating current counters as historical daily values clear in the model.

Can I report on competitors without managing their Instagram accounts?

Yes, for eligible Business or Creator accounts available through Meta's Business Discovery feature. You authorize your own qualifying account, then request supported public information about the target profiles. This is not access to every Instagram account: personal accounts and age-gated professional accounts are outside this feature's coverage. Private insights, messages, and restricted content are not unlocked by entering a username.

Which Instagram public metrics are available?

Catchr exposes profile metadata and current follower, following, and media counts. For returned publications, the catalog includes captions, media type, publication time, links, images or thumbnails, and like and comment counts. It also derives hashtag and caption-length fields from the caption. Reach, impressions, saves, shares, and audience demographics are not included in this public-data catalog. For your own account's private analytics, use the separate Instagram source.

Do the date filters show engagement received during that period?

The selected dates filter publications by their posting timestamp. Likes and comments are the current counts returned for those publications, not a daily record of when each interaction happened. A report for posts published last month can therefore change as those posts receive more engagement. Label it as performance of posts published in the selected period, rather than engagement generated exclusively within that period.

Can I track historical follower growth?

The follower count is a current profile snapshot. Changing the Catchr query's date range does not recover the number of followers the profile had on an earlier day. To measure growth over time, retain dated snapshots and calculate the change between them. Do not sum follower counts across publication rows: the same account total can be repeated without representing additional people.

How can I compare engagement across Instagram profiles?

Compare likes and comments per returned post alongside posting volume, media format, and the time each post has had to accumulate interactions. If you calculate engagement relative to followers, state the formula and that it uses the current follower count; it is not a reach-based engagement rate. Keep profiles and publication IDs distinct, and use the permalink to inspect outliers before declaring a content format or competitor more effective.

Can I analyze hashtags and Reels performance with public data?

You can group returned publications using media type and the hashtags found in their captions, then compare available likes and comments. This is analysis of the configured profiles' publications, not a search of every Instagram post using a hashtag. The public-data catalog does not include Reel play counts, watch time, or retention. Avoid treating a video thumbnail or media-type label as evidence that those private performance metrics are available.

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