QuickBooks Online
- 2 minutes to read
Summary
Power BI QuickBooks Online connector enables connecting to your QuickBooks Online account and viewing, analyzing, and reporting on your company QuickBooks data in Power BI.
Release state: Beta
Products: Power BI Desktop, Power BI Service (Enterprise Gateway)
Authentication Types Supported: QuickBooks Online account
Prerequisites
To use the QuickBooks Online connector, you must have a QuickBooks Online account username and password.
The QuickBooks Online connector uses the QuickBooks ODBC driver. The QuickBooks ODBC driver is shipped with Power BI Desktop and no additional installation is required.
Capabilities Supported
- Import
Connect to QuickBooks Online
To connect to QuickBooks Online:
In the Get Data dialog box, enter QuickBooks in the Search box, select QuickBooks Online (Beta) from the product-specific data connector list, and then select Connect.
Select Continue in the Preview connector message.
Select Sign in to sign into your QuickBooks Online account.
In the following dialog, enter your QuickBooks credentials. You may be required to provide 2FA (two factor authentication code) as well.
In the following dialog, select a company and then select Next.
Once you've successfully signed in, select Connect.
In the Navigator dialog box, select the QuickBooks tables you want to load. You can then either load or transform the data.
Known issues
Beginning on August 1, 2020, Intuit will no longer support Microsoft Internet Explorer 11 (IE 11) for QuickBooks Online. When you use OAuth2 for authorizing QuickBooks Online, after August 1, 2020, only the following browsers will be supported:
- Microsoft Edge
- Mozilla Firefox
- Google Chrome
- Safari 11 or newer (Mac only)
For more information, see Alert: Support for IE11 deprecating on July 31, 2020 for Authorization screens.