quickbooks online (qbo) - power bi connector

[Anonymous]

hi,

kindly advise if the following restriction (snapshot fromhttps://docs.microsoft.com/en-us/power-bi/service-connect-to-quickbooks-online) is still ongoing for non-us qbo connection to ms power bi:

if yes, does it mean that the workaround to this is to use 3rd party connectors that will enable ms power bi connection to non-us qbo? may i have few list of the 3rd party options, please?

tks: -nik-

[dblosser]

The qbo connector is missing tables,  ie Aggreate xml fields do not show but do in other products. Why?

[Brianyoung]

The restriction for non-US QBO in Power BI still applies. You can use 3rd-party tools like Skyvia, which syncs data easily, or exploring other connectors like Zapier or CData.

[karaoan]

For consolidation, planning and budgeting options with multiple QuickBooks (and other accounting/ SaaS) companies you might want to look at: https://www.acterys.com  The solution automatically loads all data to Azure SQL Server - a much faster and robust environment than API integration in Power BI. It also includes a set of ready-made Power BI reports with special financial reporting, planning and forecasting features through the Acterys Power BI Visuals and Apps: Business Apps – Microsoft AppSource as well as an Excel-Add-in with a live connection to the QuickBooks data.

[Anonymous]

Noted with thanks, @karaoan.

I'll study about them abit further.
KRgds, -Nik

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

You could try to use QQube (https://clearify.com/) to extract data out of QuickBooks.  Moreover, I researched some blogs that may help you.

QuickBooks to Power BI

Quickbooks Analysis via QQube!

Extract Data from QuickBooks with QXL

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

many thanks for helping me here, Xue Ding

it seems that qqube doesn't support qbo - which is my requirement.

the other 2 options (stitch & qxl) seem to support qbo.

kind regards, -nik-