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
QuickBooks Online has deprecated support for Internet Explorer 11, which Power Query Desktop uses for authentication to online services. At this time, users will be impaired from authenticating, but stored credentials should continue to work until their existing authentication tokens expire.
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.
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.
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.