Finance, ERP and payments · data source guide
QuickBooks Online data in Power BI
Connector status
No connector of its own in Microsoft's list
QuickBooks Online is not in Microsoft's current Power Query connector index (Quickbase, which is listed, is an unrelated product). Use report exports, an accounting-data sync, a certified third-party connector or the API.
Checked against Microsoft Learn's Power Query connector list on 5 November 2026. Connectors change; check the list before you build.
How to get QuickBooks Online data into Power BI
In order of preference for a report that refreshes on its own.
- 1
Export reports to Excel
Export the Profit and Loss, Balance Sheet or General Ledger report to Excel each month and load them with the Excel connector. Unpivot the period columns in Power Query so months become rows.
- 2
Use the general ledger, not formatted reports
For a model that slices by account, class and period, export the General Ledger or Transaction Detail by Account; formatted P&L exports carry subtotals that double-count when summed.
- 3
Sync or third-party connector
For scheduled refresh, sync QuickBooks into a database with an integration tool, or use a certified third-party connector from Microsoft's list that covers QuickBooks Online.
- 4
API
QuickBooks Online's accounting API uses OAuth 2.0 with short-lived tokens. 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).
Typical QuickBooks Online KPIs
Table and column names in the DAX are illustrative: rename them to match your model.
Revenue
Income accounts in the period.
Revenue = CALCULATE ( SUM ( GL[Amount] ), Accounts[Type] = "Income" )Gross margin %
Revenue minus cost of goods sold, over revenue.
Gross Margin % = DIVIDE ( [Revenue] - [COGS], [Revenue] )Operating expenses vs budget
Expense accounts against the budget sheet.
Opex Var = [Opex] - [Opex Budget]Days sales outstanding
Receivables divided by average daily revenue.
DSO = DIVIDE ( [AR Balance], DIVIDE ( [Revenue L90D], 90 ) )Cash runway (months)
Cash balance divided by average monthly net burn.
Runway Months = DIVIDE ( [Cash Balance], -[Avg Monthly Net Cash Flow] )Modelling notes for QuickBooks Online
- Signs: income and expense signs differ between exports; normalise in Power Query so revenue is positive.
- Subtotals in formatted reports double-count; model from transactions where possible.
- Closed periods can be reopened; refresh at least the last two months.
Templates for QuickBooks Online data
Free page layouts with a background, theme JSON and PBIP project. Swap the sample tables for your own queries.
Executive template
Executive KPI ScorecardFree Power BI executive dashboard template: five headline KPIs, revenue vs target trend, unit breakdown and a scorecard table on one 16:9 page.
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.
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.
More by department: Finance templates · Executive templates
Visuals for QuickBooks Online 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
Bullet ChartExecutive KPI scorecards (5-10 KPIs in a grid); Sales attainment across reps or regions
Visual
KPI CardExecutive dashboard KPI row (revenue, customers, NPS, churn); SaaS metrics card (MRR, ARR, logo growth)
Visual
HeatmapHour-of-day × day-of-week traffic or activity patterns; Correlation matrix between dozens of numeric metrics
QuickBooks Online and Power BI: questions
Is there a QuickBooks Online connector in Power BI?
Not in Microsoft's Power Query connector index as of 5 November 2026. Quickbase, which is listed, is a different product.
Can I build a P&L in Power BI from QuickBooks exports?
Yes. Export the general ledger, map accounts to P&L lines in a small mapping table, and build the statement with a matrix. The finance templates include a P&L layout.
Related data sources
Other sources teams often combine with this one.
No connector of its own in Microsoft's list
Xero in Power BIXero data in Power BI
No connector of its own in Microsoft's list
NetSuite in Power BINetSuite data in Power BI
Connector in Microsoft's list
Excel in Power BIExcel data in Power BI
QuickBooks Online 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 QuickBooks Online 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.