Starter
For freelancers and small teams.
$ 24 /mo
Billed monthly · cancel anytime
Platforms3
Accounts10
Load your Facebook Ads campaigns, ad sets, and ads into Power BI with a single Catchr query URL, then model spend, ROAS, and purchases alongside the rest of your data.
.svg)
Facebook Ads query · Power BI format
Facebook Ads
One source
Saved query
API URL
Power BI
Web · Import
Used by the world's leading companies
Start from the Meta Ads overview or Meta Ads campaign and platform templates instead of an empty report.
When you build the query for a template, select every metric and dimension it uses, otherwise some visuals stay empty.
The Facebook Ads connector exposes 440 metrics and 233 dimensions.
A practical starting point for a Power BI model: Spend, Impressions, Clicks, Purchases, and Purchase value as values, with Date, Campaign, Ad set, Ad, Placement, and Country to slice them.
For lead generation or app campaigns, swap purchases for Leads or Mobile App Purchases.
Available metrics
Available dimensions
Facebook Ads
3 advertising accounts
Connected
Google Ads
2 advertising accounts
Connected
Google Analytics 4
1 web property
Connected
HubSpot
1 CRM portal
Connected
No. Power BI used to include a Facebook connector, but Microsoft retired it in April 2020 after changes to Facebook API permissions. You can still import a CSVexport from Ads Manager with Get data > Text/CSV, which gives you a static snapshot, or load the data through a connector such as Catchr.
In Ads Manager, open your report and use Export to download the table as a CSV or Excel file. For data that stays current without new exports, the Meta Marketing API is the source: either through your own script, or through a connector that handles authentication, pagination, and API changes for you.
It depends on your Power BI capacity. On shared capacity, which covers Power BI Pro, you can schedule up to 8 refreshes per day, and each refresh must finish within two hours. On Premium, Premium Per User, or Fabric capacity, you can schedule up to 48 refreshes per day. There is no limit on the Catchr side.
No gateway is needed for cloud sources that Power BI can reach directly, which is the case for a Catchrquery URL. Enter the data source credentials once in the semantic model settings, then set the schedule. Keep the URL as a fixed address: URLs assembled dynamically in Power Query usually cannot be refreshed in the service.
Not directly. Catchr connects Facebook Ads to Power BI using Import mode through the Web connector. You can configure scheduled refreshes in Power BI to keep your reports updated automatically.
ong date ranges and many breakdowns make the response heavier. The Power BI Web connector waits 100 seconds by default, and you can raise this limit with the command timeout setting under Get data > Web > Advanced. Splitting the query by period or removing breakdowns you do not use also speeds up the load.
Our team is always here to answer any questions you may have about our data connector.
Connect your marketing platforms and build a data workflow your entire agency can use.
.svg)
.png){kind=logo}
.svg){kind=logo}
