Connect To QuickBooks From Power BI: Script Error Solved!

Issue:

If you have recently tried to connect to QuickBooks from Power BI using the QuickBooks Online connector, there is a high chance that you may have come across a very unusual ‘Script error’ message. This error message prevented users to connect to Power BI using the native connector. I did some research on troubleshooting this issue but hardly found any clear solutions online. Hence this blog!

Reason:

According to a statement from Microsoft: Due to security requirements, starting Sept. 8, 2020, only Chromium-based embedded browsers will be supported for QuickBooks Online Connection Authorization screens.

Intuit has now stopped supporting Microsoft Internet Explorer 11 (IE 11) for QuickBooks Online. So, if you use OAuth2 for authorizing QuickBooks Online, only the following browsers are supported:

  • Microsoft Edge
  • Mozilla Firefox
  • Google Chrome
  • Safari 11 or newer (Mac)

Troubleshooting:

Power BI by default (in most cases) uses IE for its authorization screens. Now as Intuit has stopped supporting IE, the default configuration for login must be changed from IE to another browser, in our case Microsoft Edge. In this way, the next time you try to log in from Power BI, it will use Edge for its authorization. (Pls note that this method will only change the default login method for QuickBooks. All the other connectors will still use PBI’s default authorization screen)

Follow the steps below to change the default authorization screen for QuickBooks:

  • Download and Install the new Edge Chromium browser, (at least beta) from https://www.microsoftedgeinsider.com/en-us/download
  • In your system,
    Open Control Panel -> System -> Advanced system settings -> Advanced -> Environment variables.

    Under ‘System Variables’,
    Click New -> Set Variable name as PQ_EnableEdgeChromiumOAuth and Variable value as true -> Click OK

  • You should now be able to log in to QuickBooks Online.

Karan Nair
Team Lead – Data Analytics
Addend Analytics

Addend Analytics is a Microsoft Power BI-partner based in Mumbai, India. Apart from being authorized for Power BI implementations, Addend has successfully executed Power BI projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia. Get a free consultation now by emailing us at kamal.sharma@addendanalytics.com.