Finance, ERP and payments · data source guide
Stripe data in Power BI
Connector status
No connector of its own in Microsoft's list
Stripe has no connector of its own in Microsoft's index. Stripe's own data products can deliver data to a warehouse that Power BI can read; exports and the API are the other paths.
Checked against Microsoft Learn's Power Query connector list on 5 November 2026. Connectors change; check the list before you build.
How to get Stripe data into Power BI
In order of preference for a report that refreshes on its own.
- 1
Stripe data in a warehouse
Stripe offers ways to get account data into a data warehouse (check Stripe's documentation for the products available to your account). Connect Power BI to that warehouse with its connector, for example Snowflake.
- 2
Dashboard exports
Export payments, payouts or subscriptions from the Stripe Dashboard as CSV for a first version, and store them in SharePoint or OneDrive for refresh.
- 3
API
Stripe's API is paged by cursor and authenticated with a secret key that must never sit in a shared report. Power BI's Web connector can call a REST API, but paging, authentication tokens and scheduled refresh in the Service take care: dynamic URLs built from parameters may not refresh in the Service unless the base URL is static (use Web.Contents with RelativePath and Query).
- 4
Amounts are in the smallest unit
Stripe amounts are integers in the currency's smallest unit (cents for USD). Divide by 100 (or by the currency's factor) in Power Query.
Typical Stripe KPIs
Table and column names in the DAX are illustrative: rename them to match your model.
Gross volume
Successful charge amounts in the period.
Gross Volume = CALCULATE ( SUM ( Charges[AmountMajor] ), Charges[Status] = "succeeded" )Payment success rate
Successful charges divided by attempted charges.
Success Rate = DIVIDE ( CALCULATE ( COUNTROWS ( Charges ), Charges[Status] = "succeeded" ), COUNTROWS ( Charges ) )Refund rate
Refunded amount divided by gross volume.
Refund Rate = DIVIDE ( SUM ( Refunds[AmountMajor] ), [Gross Volume] )Dispute rate
Disputed charges divided by successful charges.
Dispute Rate = DIVIDE ( COUNTROWS ( Disputes ), CALCULATE ( COUNTROWS ( Charges ), Charges[Status] = "succeeded" ) )MRR
Monthly recurring revenue from active subscriptions, normalised to a month.
MRR = SUMX ( FILTER ( Subscriptions, Subscriptions[Status] = "active" ), Subscriptions[MonthlyAmount] )Modelling notes for Stripe
- Never put a Stripe secret key in a report's Power Query; use a warehouse or a secured dataflow.
- Annual plans: normalise to monthly for MRR, and keep billed revenue as a separate measure.
- Currency: report per currency or convert with a rate table; Stripe balances are per currency.
Templates for Stripe data
Free page layouts with a background, theme JSON and PBIP project. Swap the sample tables for your own queries.
Finance template
CFO OverviewPower BI CFO dashboard template with revenue, EBITDA, cash and opex KPIs, a 13-week cash view, EBITDA bridge, P&L matrix and opex mix.
Finance template
Profit & Loss StatementPower BI P&L statement template: a full-height income statement matrix with actual, budget and prior year, margin KPIs and expense drivers.
Finance template
Budget vs ActualBudget vs actual Power BI template for cost-centre owners: actual, budget, variance and burn-rate KPIs, monthly combo chart and variance ranking.
SaaS template
SaaS Metrics: MRR & ChurnPower BI SaaS metrics dashboard template: MRR, net revenue retention, churn and CAC payback KPIs, MRR movement chart, churn trend and cohort retention matrix.
Finance template
Accounts Receivable & CollectionsPower BI accounts receivable dashboard template: open and overdue AR, DSO trend, aging buckets by segment, a collector worklist and top overdue customers.
Finance template
Travel & Expense ManagementPower BI travel and expense (T&E) template: spend vs budget by month, spend by expense type, out-of-policy claims and days to reimburse.
Power BI visuals for SaaS · More by department: SaaS templates · Finance templates
Visuals for Stripe KPIs
Chart types that suit these KPIs, with data shapes and example prompts.
Visual
Waterfall ChartRevenue walk: prior year → price → volume → mix → FX → current year; Budget reconciliation: budget → categorical variances → actual
Visual
HeatmapHour-of-day × day-of-week traffic or activity patterns; Correlation matrix between dozens of numeric metrics
Visual
KPI CardExecutive dashboard KPI row (revenue, customers, NPS, churn); SaaS metrics card (MRR, ARR, logo growth)
Visual
Calendar HeatmapDaily sales or revenue intensity across the year; Website traffic patterns (day-of-week × week-of-year)
Stripe and Power BI: questions
Is there a Stripe connector for Power BI?
Not in Microsoft's Power Query connector index (checked 5 November 2026). Use a warehouse, exports or the API.
Why are my amounts 100× too big?
Stripe stores amounts in the smallest currency unit. Divide by 100 for two-decimal currencies; zero-decimal currencies such as JPY need no division.
Related data sources
Other sources teams often combine with this one.
No connector of its own in Microsoft's list
Shopify in Power BIShopify data in Power BI
No connector of its own in Microsoft's list
QuickBooks Online in Power BIQuickBooks Online data in Power BI
No connector of its own in Microsoft's list
Xero in Power BIXero data in Power BI
Stripe is a trademark of its owner. Product names are used only to describe compatibility; VizForge is not affiliated with, endorsed by or sponsored by the owner or by Microsoft.
Design the Stripe report page first
Lay out KPI cards and visual slots in the free Design Studio, then export the background, theme JSON and a PBIP project to bind to your data.
The design studio for Power BI. Free, in your browser, no sign-up.