Getting QuickBooks Online data into a usable Power BI format sounds simple until you actually try it. The obstacle is rarely the connection itself, it's the shape of the data once it arrives. Power BI's native QuickBooks Online connector spreads everything across more than 100 separate tables, and finding the handful of columns that actually matter for a given report means digging through a pile of tables that mostly don't apply to you.
This article covers a different approach: rather than working through that native connector, we'll walk through Versich's QuickBooks Online connector, which restructures the same underlying data into a small number of report-ready tables, Profit & Loss, Balance Sheet, Cash Flow, before it ever reaches Power BI. The advantages are straightforward:
- Everything lands pre-organized into tables built for reporting, so you pick the table you need instead of searching through a hundred-plus options.
- Multiple QuickBooks Online accounts can be connected and consolidated into a single dataset.
- The resulting data format is consistent and predictable across every connected account.
Who This Approach Actually Matters For
Not every QuickBooks Online user needs this. It tends to matter most for a specific set of situations:
- Anyone managing more than one QuickBooks Online account: bookkeeping firms juggling client books, franchise operators with a separate file per location, property managers with one account per building, or any owner running several legally separate companies. Consolidating all of it into one place rather than flipping between separate QuickBooks logins is the core win here.
- Anyone who's hit the analytical ceiling inside QuickBooks Online itself. QuickBooks's own reporting is fine for standard statements, but plenty of finance teams find themselves wanting cross-period comparisons, custom groupings, or visuals that the native reporting simply wasn't built to produce.
- Anyone wanting to combine financial data with something QuickBooks doesn't track at all, blending P&L figures with pipeline data from a CRM, for instance, or with operational metrics from a separate system, all inside one Power BI report.
If any of that sounds familiar, the rest of this article covers exactly how to set it up.
How the Setup Actually Works
Rather than connecting Power BI directly to QuickBooks Online, this approach routes the data through an Azure SQL database first, and Power BI connects to that database instead. A few things make this detour worthwhile rather than an unnecessary extra step:
- QuickBooks Online accounts, especially ones with years of transaction history, can hold a genuinely large volume of data. Azure SQL is built to handle that kind of volume and the repeated querying it takes to keep it current, which frees Power BI up to focus on visualization rather than heavy data processing.
- Azure SQL and Power BI are both Microsoft products, so the connection between them is well-supported and reliable.
- Versich's connector reshapes the data on its way into Azure SQL, so what eventually reaches Power BI is already organized into clean P&L, Balance Sheet, and Cash Flow tables rather than something that still needs significant rework before it's reportable.
Setting It Up
- Register for a free account on the Versich Power BI Connectors platform.
- Go to the Install tab. This is where the necessary tables get created in your database of choice, either your own Azure SQL Server or a database Versich hosts on your behalf. Click Install to have the script generate those tables; data starts flowing in once your QuickBooks account is connected.
- Once the tables exist, you'll be directed to the connection menu. Click “Connect New Company” to begin linking a QuickBooks Online company.
- Select the company you want to connect and confirm. You'll be returned to the table view, where the newly connected company now appears listed.
- Track the load in the Refresh Status tab; once every table shows 100%, the data is ready to use.
Once the full historical pull finishes, the system handles ongoing refreshes automatically going forward, on a default 30-minute schedule, with custom refresh intervals available depending on what a given setup actually needs.
- Back in the Install tab, click “Send Database String” to receive an email with the server name, database name, and login credentials needed to connect Power BI.
- In Power BI, use the Azure SQL Server connector and enter those details to pull the data in directly.
What the Resulting Data Actually Looks Like
With the connection live, a free QuickBooks Online Power BI template is available to get started quickly, or a report can be built from scratch against the same tables.
The Profit & Loss Table
Each row in this table represents a single transaction: a date, a dollar value, and a description explaining what that transaction actually was. Scrolling further across the table, every transaction is grouped into the account hierarchy familiar from QuickBooks's own P&L report, with the ability to filter by accounting method, cash or accrual, and by class. The QuickBooks account name is included as well, which is what makes consolidating multiple companies into one table possible in the first place.
Because of that structure, building a full P&L analysis, broken out by month, by class, by account, by company, only requires pulling from this single table rather than stitching several together.
The Balance Sheet Table
This table mirrors the same logic, structured to match QuickBooks's own Balance Sheet report. Each row again carries a transaction date, amount, and description, with accounts grouped into three hierarchy levels matching the standard Balance Sheet layout, Assets and Liabilities & Equity at the top, breaking down into more specific categories beneath. The same cash/accrual filter and QuickBooks account name carry through here too.
As with the P&L table, a complete Balance Sheet report, across one company or many, comes from this single table without needing additional blending.
Note: A bookkeeping practice managing a dozen or more separate client companies tends to see the clearest payoff from this setup, since consolidating that many accounts manually inside QuickBooks Online's own reporting simply isn't practical.
Where This Leaves Things
Restructuring QuickBooks Online data into purpose-built P&L, Balance Sheet, and Cash Flow tables before it reaches Power BI removes most of the manual blending work a report builder would otherwise face, and it's what makes consolidating multiple QuickBooks accounts into a single dashboard genuinely practical rather than a multi-hour exercise every time the data refreshes. The connector continues to be actively maintained, with new capabilities added over time and ongoing support available to anyone using it.
