What is the best ODBC to use on Quick Books using Power BI Desktop?

[CHooi]

Hi everyone,

I am new with Power BI Desktop and I am trying to figure out what is the best way to connect to QB using Pwer BI Desktop. I would appreciate it if someone can give me some guide based on their experiences. I have been looking at qqube, cdata and qodbc among others. I also need this to have good documentation if possible to help me in the process of understanding the QB database better.

Cherrel

[v-ljerr-msft · Accepted solution]

Hi @CHooi,

Based on my research, QQube is usually used to extract data from Quick Books into Power BI currently.

Here is an idea shared on Power BI Ideas that requests the QuickBooks desktop connector for your reference. Many users have shared their experience there in the comments. 

In addition, following are some articles about QQube and Power BI:

https://clearify.com/wiki/view/1407/creating-powerbi-charts

https://powerpivotpro.com/2015/12/quickbooks-analysis-via-qqube/

Regards

[CHooi]

Hi v-ljerr-msft,

Many thanks for your reaction. I was in the process of evaluating QQube, CData and QOdbc.

I am glad with your help and I think I have a better idea on how to proceed. QQube here we go, thanks a lot!

Regards.