Connect RevenueCat to Power BI

Connect your RevenueCat project in Catchr, then build a Power BI-format query for the indicators you need. Preview the response and import the generated URL with Get data > Web in Power BI Desktop. Keep the project, currency, period labels and update timestamps. Model overview snapshots separately from revenue over a date range so a date slicer cannot imply that a current MRR value is historical.

Catchr includes active subscriptions, active trials, MRR, active users and new customers over the last 28 days, plus revenue measures. It also exposes project identifiers, metric periods and last-updated timestamps. Use the period labels to distinguish a current snapshot from a rolling-period indicator.

Overview indicators are current snapshots or fixed last-28-day measures. They are not historical daily records. Catchr retrieves that overview separately from date-range revenue. To report revenue for a chosen month, use the period revenue fields rather than relabeling the overview's last-28-day value.

Yes. Catchr provides gross revenue, revenue excluding taxes, and revenue after taxes and commissions. Choose the definition that matches your comparison and show it in the chart title. Do not compare a gross-revenue scorecard with an app-store proceeds statement as if they were the same measure.

Not necessarily. RevenueCat's proceeds estimate and the store's payout use different timing and reporting rules. Apple's fiscal periods also differ from calendar months. Use the app store's financial report for payout reconciliation and the RevenueCat dashboard for subscription and revenue performance.

Use the last-updated fields supplied with the overview metrics. A new dashboard refresh does not guarantee that every upstream metric has just been recalculated. Display the timestamp next to important cards, and keep recent data provisional when comparing it with a later RevenueCat export.

Yes. Add an advertising source such as Apple Search Ads to compare acquisition investment with app revenue. Align project, period and currency. An aggregate revenue-to-spend comparison is a business trend; it does not assign each subscription to an individual advertising campaign.

No. A normal refresh reloads the RevenueCat overview returned now; it does not append a new daily MRR snapshot to a historical table. Store dated observations separately if you need an MRR trend. A successful Power BI refresh and the RevenueCat metric update timestamp also describe different events, so show the latter when freshness matters.