Connecting to Power BI in the UK

You need a 3rd party connector. Otherwise, you may consider having another BI app to integrate with QBO natively.

I have connected Power BI to Quickbooks multiple times as a Power BI consultant. I have developed my own script to do this which has multiple benefits over the native connector:
- You can extract data from multiple QBO accounts and combine it together (relevant for owners of multiple businesses and accountants)
- All P&L data is combined in a single table. You can also drill down to transactions that make up value of every account, filter by day and see data on accrual vs cash basis. Same for Balance Sheet, Cash Flow, Account Receivables, Budget, etc.
Here is more info about it: https://vidi-corp.com/how-to-connect-power-bi-to-quickbooks-online-reports/

My email is [email address removed]

Hi, yes, I used this Power BI connector: https://vidi-corp.com/connect-quickbooks-online-to-power-bi/

This provider also offers free templates that were useful

I know I'm late to this party, but it will hopefully assist anyone looking for help; note that it only works with QB Service/online.

Tugger offer various connectors (of which QuickBooks is one); a free trial is offered, as well as report templates that can be used to import data via an OData link. They are easy to find via Google, but here's the link: https://tuggerapp.com/QuickBooksIntegration.

They only recently added support for QuickBooks and although I'm not an accountant, I come to this from the technical side, everything looks good.

Connecting QuickBooks Online to Power BI isn’t direct since there’s no built-in connector. Many use third-party solutions like CData or Tugger to pull data for reports. I’ve used Skyvia, which runs quietly in the background and handles complex mappings, making Power BI dashboards much easier to build.