Power BI reports,loaded with your ClickFlare profit

Load your ClickFlare revenue, cost and profit into Power BI and report on them next to the rest of your business. There is no native connector: Power BI queries the ClickFlare API directly, with no server in between, and each refresh pulls the latest numbers.

PBI
Power BI
Microsoft business analytics

Power BI integration at a glance

How it connects
Power BI queries the ClickFlare API directly
What syncs
Visits, clicks, conversions, revenue, cost and profit
How fresh the data is
Each time you refresh the dataset
What you can optimize
Campaigns, offers, landers and traffic sources by profit
Works with
Power BI Desktop
Good to know
No native connector. Refresh in the Power BI service is untested.
BI & dashboards
Direct API query
Refresh for new data

Your ClickFlare numbers in your Power BI model

No middle layer

Power BI calls the ClickFlare API itself. No script or server sits between your tracker and your model.

Finance sees the same P&L

Revenue, cost and profit by day and campaign land in the same Power BI model your finance team uses for spend.

Any breakdown you need

Load campaign, offer, lander, country, device, date or tracking field cuts by changing what the query asks for.
How it works

From ad click to profit per campaignattributed revenueattributed salesa matched conversionautomated actionyour dashboardsclosed revenue

01
Your ad
Visitor clicks
Ad on Power BI
02
ClickFlare
Click recorded
Every click gets its own ID
03
Your offer
Conversion
Lead, sale or custom event
04
ClickFlare
Sent back to Power BI
Through the Conversion API or postback
05
Cost API
Spend pulled in
Power BI cost matched to each campaign
01
Your ad
Power BI click
Placement, device and country come along
02
ClickFlare
Click recorded
Zone, site and device data stored
03
Offer or lander
Visitor converts
On your page or the offer
04
ClickFlare
Conversion logged
With payout and event type
05
Postback
Reported to Power BI
So its optimization sees the result
01
Your ad
Visitor clicks
Any traffic source
02
ClickFlare
Click recorded
Every click gets its own ID
03
Your article
Keyword block
Click ID passed to the feed
04
Results page
Paid click
Conversion fired to ClickFlare
05
Power BI API
Revenue matched
Pulled on a schedule and reconciled
01
Your ad
Visitor clicks
Any traffic source
02
ClickFlare
Click recorded
The click follows the visitor to the offer
03
Power BI
Offer or call
The network tracks the action
04
Power BI
Conversion
Lead, sale, call or rebill
05
Postback
Payout in ClickFlare
Matched to the original click
01
Your ad
Visitor clicks
Any traffic source
02
ClickFlare
Click recorded
Every click gets its own ID
03
Power BI
Store or funnel
Click ID kept through checkout
04
Events
View, cart, checkout
Each step tracked
05
ClickFlare
Purchase recorded
Order value matched to the ad
01
Your ad
Visitor clicks
Form, call or landing page
02
ClickFlare
Click recorded
Every click gets its own ID
03
Power BI
Lead or call stored
The ad stays linked to the lead
04
Power BI
Qualified or closed
Workflow or call rule fires
05
ClickFlare
Revenue recorded
Tied to the ad that drove it
01
ClickFlare
Event happens
Click, conversion or custom event
02
Webhook or API
Data goes out
Or comes back in
03
Power BI
Your workflow
Rules, apps or an AI assistant
04
Power BI
Action
Alert, update, pause or scale
05
ClickFlare
Back in reports
Changes show in your data
01
ClickFlare
Report data
Campaigns, sources, offers
02
ClickFlare API
Your numbers go out
Secured with your API key
03
Your setup
Scheduled refresh
A sheet, script or connector
04
Power BI
Data lands
Tables refreshed on schedule
05
Power BI
Dashboards
Blended with your other data
BI & dashboards

From ClickFlare to a Power BI table

A ready-made query from the guide asks the ClickFlare API for your report and turns the answer into a table. Refresh the dataset and the table updates with the latest revenue, cost and profit.
  • Your API key kept in a Power BI parameter
  • Recent days re-pulled on each refresh
  • Large reports loaded page by page
Today, one campaign
example
Spend pulled from Power BI
cost
$412.30
Conversions recorded
today
38
Sent back to Power BI
per event
38/38
Profit
campaign
$227.70
Example numbers. Cost and conversions sit in the same report row.
ROI per placement
example
Placement A · mobile
cost
$38.20
Placement A
revenue
$71.40
Placement A
ROI
+87%
Placement B · desktop
ROI
−42%
Example numbers. Keep the placements that pay and cut the ones that lose money.
Revenue for one click
example
Paid click
day 0
$0.00
First revenue pull
+1h
$0.41
Scheduled updates
next days
$0.58
Final pull
last sync
$0.62
Example amounts. Sync timing for Power BI is in the facts above.
Events for one click
example
Lead
day 0
$0.00
Sale
day 0
+$40.00
Upsell
day 1
+$15.00
Refund
day 9
−$15.00
Example events. Each one arrives by postback and is matched to the click.
One visitor's path
example
Product view
step 1
—
Add to cart
step 2
—
Checkout
step 3
—
Purchase
step 4
$68.00
Example order. Each event is tied to the ad that brought the visitor.
One lead, followed to revenue
example
Lead created
day 0
$0.00
Qualified
day 2
+$25.00
Deal closed
day 14
+$480.00
Renewal
day 45
+$120.00
Example values. Each stage can be its own event type in ClickFlare.
A scheduled report refresh
example
Campaigns
in the report
1,240 rows
Cost, revenue, profit
per campaign
included
Refresh
your schedule
done
Dashboards fed
Power BI
3
Example numbers. You choose the breakdowns, date range and schedule.
One event, end to end
example
Conversion recorded
event
sent
Event delivered
Power BI
received
Workflow ran
Power BI
done
Team notified
your apps
done
Example run. What happens after the event is up to your workflow.
10
Breakdowns per pull
50,000
Rows per page
2.3B
Events tracked
Setup

Connected in three steps

You need a ClickFlare account with an API key and Power BI Desktop.
  1. Create a ClickFlare API key Generate a key in ClickFlare. Power BI uses it to read your report data, so keep it private.
  2. Add the query in Power BI Desktop Store your key in a parameter and paste the guide's ready-made query. It returns your ClickFlare report as a table.
  3. Load and refresh Set the date and money column types and load the table. Refresh the dataset whenever you want the latest numbers.
app.clickflare.com/integrations
PBI
Power BI
BI & dashboards
Connected
Power BI account connected
Signed in from ClickFlare
Cost syncing
Spend matched to campaigns
Conversions sent back
Your chosen events
Power BI template selected
Macros pre-filled
Tracking URL in Power BI
Click ID captured
Conversions reported
Payout included where supported
Power BI connected
Credentials saved in ClickFlare
Conversion event set
Click ID passed to the feed
Revenue syncing
On the feed's schedule
Power BI added
Offer URL carries the click ID
Postback set in Power BI
Payout and event included
Conversions arriving
Matched to the click
Power BI connected
Click ID kept to checkout
Events mapped
View, cart, checkout, purchase
Purchases tracked
Order value in reports
Click ID stored in Power BI
Hidden field or call data
Workflow or rule set
Fires on the stage you choose
Conversions arriving
With payout and event type
API key created
Settings, then Security
Report pull scheduled
Dimensions and date range set
Power BI dashboards live
Refreshed on schedule
Connection set up
Webhook, API key or MCP
Events chosen
Only what the workflow needs
Workflow running
Tested end to end
Ready to track
Scheduled refresh in the Power BI service hasn't been tested yet. Run one refresh there before you rely on it.
Power BI setup guide
Open the guide
In your reports

What you see once it's connected

  • Revenue, cost and profit by day
  • ROI by campaign
  • Revenue by traffic source
  • Offer and lander comparisons
  • Custom conversion columns
  • Country and device breakdowns
Use cases

How media buyers run it

Finance-ready P&L

Pull revenue, cost and profit by date and campaign into the same Power BI model your finance team uses for spend.

Native → lander → offer

Rank lander and offer pairs by revenue and profit across your native campaigns.

One client per workspace

Limit a report to one client's ClickFlare workspace and share a clean view with each client.
Frequently asked questions

Power BI integration FAQ

Does ClickFlare integrate with Power BI?

Yes, through the ClickFlare API. There is no native connector, but Power BI can query the API directly with your API key and load the results as a table.

Do I need a server or script in between?

No. Power BI Desktop calls the ClickFlare API itself, so nothing runs between ClickFlare and your model.

How often does the data update?

Each time you refresh the dataset. Set the dates relative to today and every refresh re-pulls recent days.

Can I load large reports?

Yes. Larger reports load page by page. If a pull takes too long, use a shorter date range.

Does scheduled refresh work in the Power BI service?

It hasn't been tested. Publish and run one refresh in the service first. If it fails, load the data through BigQuery or a file instead.

Why don't my numbers match ClickFlare?

Use the same timezone, currency and conversion timing as the ClickFlare report you compare with, and build ratios like ROI from totals.

No items found.
Setup guides
Power BI setup guide
ClickFlare API overview
{"@context": "https://schema.org", "@graph": [{"@type": "FAQPage", "mainEntity": [{"@type": "Question", "name": "Does ClickFlare integrate with Power BI?", "acceptedAnswer": {"@type": "Answer", "text": "Yes, through the ClickFlare API. There is no native connector, but Power BI can query the API directly with your API key and load the results as a table."}}, {"@type": "Question", "name": "Do I need a server or script in between?", "acceptedAnswer": {"@type": "Answer", "text": "No. Power BI Desktop calls the ClickFlare API itself, so nothing runs between ClickFlare and your model."}}, {"@type": "Question", "name": "How often does the data update?", "acceptedAnswer": {"@type": "Answer", "text": "Each time you refresh the dataset. Set the dates relative to today and every refresh re-pulls recent days."}}, {"@type": "Question", "name": "Can I load large reports?", "acceptedAnswer": {"@type": "Answer", "text": "Yes. Larger reports load page by page. If a pull takes too long, use a shorter date range."}}, {"@type": "Question", "name": "Does scheduled refresh work in the Power BI service?", "acceptedAnswer": {"@type": "Answer", "text": "It hasn't been tested. Publish and run one refresh in the service first. If it fails, load the data through BigQuery or a file instead."}}, {"@type": "Question", "name": "Why don't my numbers match ClickFlare?", "acceptedAnswer": {"@type": "Answer", "text": "Use the same timezone, currency and conversion timing as the ClickFlare report you compare with, and build ratios like ROI from totals."}}], "dateModified": "2026-11-12"}, {"@type": "BreadcrumbList", "itemListElement": [{"@type": "ListItem", "position": 1, "name": "Integrations", "item": "https://www.clickflare.com/integrations"}, {"@type": "ListItem", "position": 2, "name": "Analytics & BI", "item": "https://www.clickflare.com/integrations/analytics-bi"}, {"@type": "ListItem", "position": 3, "name": "Power BI"}]}]}