Skip to main content
January 6, 2023
Question

Connecting to Power BI in the UK

  • January 6, 2023
  • 4 replies
  • 0 views

Hi

Has anyone managed to connect Quickbooks Online to PowerBI in the UK? In PowerBI there should be a QB app but it doesnt appear. Does anyone know if it has been removed?

Thanks

4 replies

Fiat Lux - ASIA
January 6, 2023

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

Phil TAuthor
January 6, 2023

Thanks can you recommend any you have used?

Fiat Lux - ASIA
January 6, 2023
March 19, 2024

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]

March 29, 2024

Here is the data format from it: https://vidi-corp.com/connect-quickbooks-online-to-power-bi/
Here are the dashboards that you can produce with this data: https://vidi-corp.com/product-connect-quickbooks-online-to-power-bi/

July 23, 2024

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

September 4, 2024

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.