QuickBooks Desktop connection to Power BI

[Dyl_an]

Hello,

My Company uses QuickBooks Desktop through Right Networks. We are looking to export the information from QuickBooks, into Power BI. However, I am unable to find the best method to do so. Has anyone done this previously, and if so how?

We will be looking to automate the Financial information daily as well.

If anyone has any suggestions or links which may be able to help, please comment them as I would love to take a look. 

Thank you in advance,

Dylan

[v-shex-msft]

Hi @Dyl_an,

If you mean get data to power bi side, it is possible. You can use web connector with QuickBooks rest API or QuickBooks connector to get data.

Power Query QuickBooks Online connector - Power Query | Microsoft Learn

QuickBooks Develop (intuit.com)

If you mean to integrate the QuickBooks dashboard to power bi side, I'd ;like to suggest check the QuickBooks Online connect app:

Power BI and QuickBooks Online: Finances Made Simple | Microsoft Power BI Blog | Microsoft Power BI
Regards,

Xiaoxin Sheng

[Dyl_an]

Hi Xiaoxin,

Thank you for the response.

Sadly, QuickBooks Desktop and Online are two different softwares and I don't believe the same options would apply to both.

I am going to try using the OBDC unless you may think of anything else that would work.

Best,

Dylan

[Anonymous]

Hi Dylan,

Did you ever find a solution for this? 

I'm trying to connect Quickbooks desktop to powerbi as well.

Best,

Amanda