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