Skip to main content
Phil T
Jan 6, 2023 9:59 AM UTC
Question

Connecting to Power BI in the UK

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

10 replies

Fiat Lux - ASIA
Fiat Lux - ASIA
Jan 6, 2023 10:14 AM UTC

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

Phil TAuthor
Jan 6, 2023 10:16 AM UTC

Thanks can you recommend any you have used?

Fiat Lux - ASIA
Fiat Lux - ASIA
Jan 6, 2023 11:15 AM UTC

Explore this connector

https://www.make.com/en/register?pc=quickbooks

 

or another BI app

https://go.zoho.com/LcV

 

    Vidi Corp ltd
    Mar 19, 2024 10:55 AM UTC

    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]

    Vidi Corp ltd
    Mar 29, 2024 12:33 PM UTC

    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/

    arina_k
    Jul 23, 2024 12:38 PM UTC

    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

    NSTT
    Sep 4, 2024 8:41 AM UTC

    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.



    Terms & ConditionsAccessibility statement