cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bdurham
New Member

Can Power BI be Connected to Quickbooks Enterprise?

Can Power BI be Connected to Quickbooks Enterprise?

1 ACCEPTED SOLUTION
mllopis
Microsoft
Microsoft

Currently only Quickbooks Online is supported. Please leave a vote for this feature if you find it important:

https://support.powerbi.com/forums/265200-power-bi/category/87276-data-sources

 

View solution in original post

4 REPLIES 4
BetterIdeaGroup
Helper II
Helper II

You can use the ODBC features in Quickbooks Enterprise to get information into PowerBI. it is NOT perfect by a long shot but it is a connection to give you some raw data if you want to fight thru getting the views connected (not obvious how to do it but possible).  Be careful trying the QODBC connector as I have found that it fails with PowerBI.

I have found that to use PowerBI to report on QuickBooks data your best option is a 3rd party product called QQube  which extracts all the QuickBooks (QB) data into a local sybase database. The database model is optomized for reporting so it really is PERFECT for using with PowerBi.  It  comes with PowerBi Templates (Desktop files) that cover nearly every area you would want to report on.

 

I am certified on the product so do let me know if you need help getting QQube or getting it working.

 

Ernest
3c2cc3da3a823a09f7a82f1dd6e32955.png

quickbooks12
New Member

Hi,


Thanks for sharing your QB Experience  to us. I would also include some information it. When we transder all QuickBooks Online data to Quickbooks desktop this problem does'nt happens. In QuickBooks Online right side there is always a option Contact to our Support or Dial
1-888-771-0476 its a QuickBooks Tech Support Number

mllopis
Microsoft
Microsoft

Currently only Quickbooks Online is supported. Please leave a vote for this feature if you find it important:

https://support.powerbi.com/forums/265200-power-bi/category/87276-data-sources

 

View solution in original post

jaschro
Frequent Visitor

Respectfully, I would call this only the most minimal and partial of integrations.  I've taken the PowerBI edx class and created a variety of PowerBI models, and I've spent a long time trying to get PowerBI to pull data from Quickbooks Online.  Unfortunately, the PowerBI service only sees a few tables, enough to do an A/R aging, and a few high level summaries, but not much else.  The PowerBI desktop sees a different view.  It sees about 20 tables, but the tables aren't properly linked, and much of the data appear to be unreachable.   I think this is good for a very first release, but there's a long way to go to make this actually usable. 

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors