cancel
Showing results for 
Search instead for 
Did you mean: 
ZNS1
Level 1

Integration of Quickbook and Power BI

Does anyone know if it is Possible to integrate Quickbooks with Microsoft Power BI in such a way that we can see the invoicing data on quickbooks to our Dashboard on Power BI?

For example all the status of our invoices, such as pending, paid, etc, being displayed on the dashboard. 

If anyone can help with this would be great.

12 Comments 12
ShiellaGraceA
QuickBooks Team

Integration of Quickbook and Power BI

Good news, @ZNS1.

 

QuickBooks Online (QBO) lets you connect with Microsoft Power BI. All you have to do is sync the app into QBO. Let me walk you through how.

 

  1. Open your QuickBooks account.
  2. Go to Apps, then search "Microsoft Power BI" in the field.
  3. Select the app, then Learn more.
  4. Click Buy now.

With these steps, you're able to sync the app to QBO. You can learn more about this app at this link here: https://quickbooks.intuit.com/app/apps/appdetails/powerbi/en-us/

 

I'll also share with you our page about apps just in case you need some reference to app-related concerns.

 

Please don't hesitate to comment below if you have other questions or concerns. We're always here to lend a hand. Thanks for posting and have a nice day ahead.

Ramm6
Level 2

Integration of Quickbook and Power BI

Hi @ShiellaGraceA!

 

Does QuickBooks Desktop allow us to connect to Microsoft Power BI as well?

 

Thanks!

Fiat Lux - ASIA
Level 15

Integration of Quickbook and Power BI

@Ramm6 

I would recommend another BI app to integrate with QBD. The fee is lower and it offers many features.

https://go.zoho.com/M5c

 

serghio
Level 1

Integration of Quickbook and Power BI

Is it possible to integrate QuickBooks Desktop version with Power BI?

If so, does it sync well?

Thanks.

JamesAndrewM
QuickBooks Team

Integration of Quickbook and Power BI

Good to see you again, @serghio. Thanks for joining the thread and for posting a question. I'll share some suggestions to help you achieve your goal.

 

You may want to find some third-party applications that allow you to pull raw data from various sources and create meaningful reports in the Apps for QuickBooks Desktop webpage or by following this link: https://desktop.apps.com/home.

 

Once on the page, follow the steps below:

 

  1. Go to All Applications.
  2. On the search tab, type in the clue word of the specific app you're looking for.
  3. Click the magnifying glass to search.

 

You can utilize this article to customize any report: Customize reports in QuickBooks Desktop.

 

Thanks for dropping by. We're available 24/7 to tend to each of your concerns. Don't hesitate to post here again. Stay safe!

ntesllc
Level 2

Integration of Quickbook and Power BI

serghio 

I am currently using Power BI with QBO.

1. Log into your QBO account first.

2. Launch Power BI Desktop & choose Get Data; in the search window type in Quickbooks

3. Select QBO Beta and connect.

This will download all tables and does not download GeneralLedger table.

For that you will need to create a blank query next:

Power BI Desktop ---> Transform Data--->New Source ---->Blank Query:

insert the following and it will take you to a list of tables and click on GeneralLedger :

= Source{[Key="generalledger"]}[Data]

 

serghio
Level 1

Integration of Quickbook and Power BI

Thank you. Does anyone know if Power BI also connects with QuickBooks Desktop version?

serghio
Level 1

Integration of Quickbook and Power BI

Thanks for the feedback James but I would llke to specifically found out if Power BI is able to connect to QuickBooks DESKTOP version and if so, if it works well. Thanks.

serghio
Level 1

Integration of Quickbook and Power BI

Thank you. Do you know if Power BI connects to QuickBooks DESKTOP version?

LeizylM
QuickBooks Team

Integration of Quickbook and Power BI

Hi there, serghio. 

 

Allow me to share some information about connecting Power BI to QuickBooks Desktop (QBDT). 

 

Currently, the option to connect Power BI to QuickBooks Desktop is unavailable. As a workaround, you can utilize a third party that integrates with QBDT.

 

You can visit the QuickBooks Apps site and look for an app that meets your business needs. Another way is by going to the Apps menu on the left panel. 

 

In case, you'll want to personalize and add specific info to your invoice and other form styles in QuickBooks Desktop To know more about it, you can check out the detailed steps in this article: Use and customize form templates.

 

Please don't hesitate to get back here if you have clarification about this. I'm just around the corner to help. Have a good one and keep safe. 

serghio
Level 1

Integration of Quickbook and Power BI

OK good to know it does not work with QBDT. Thank you.

NSTT
Level 1

Integration of Quickbook and Power BI

I know I'm late to this party, but it will hopefully assist anyone looking for help, and the following solution should work as the initial OP was an online query, not QuickBooks Desktop.

 

Tugger offer a free trial, and report templates that can be used to import data via an OData link.

 

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

 

Setup is pretty straightforward: sign up > add your connector > wait for it to get your data > download the report template > import your data > Voila, a working report.

 

They are easy to find via Google, but here's the link: https://tuggerapp.com/QuickBooksIntegration.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us