Forum Discussion
Quickbooks Online Authentication Error
Having the same issue, where exactly are the system variables changed to mark PQ_EnableEdgeChromiumOAuth as true? Thank you.
I changed them (I assume this is correct) by right clicking windows start, click settings, then type in environment and it will pull up "Edit System Environment Variables" then on Advanced tab click Environment Variables and from there you will need to add it....
But I'm still getting the same error after adding this to the Environment Variable.
- Sohrab5 years agoAdvocate II
Have you confirmed that you installed the Edge *BETA* build?
If you follow the instructions on https://docs.microsoft.com/en-us/power-query/connectors/quickbooksonline and are using the default QBO connector, this works. If you are using the legacy Quickbooks.Tables() connector like I was, I wrote up a post describing how to get that working too: http://www.decodeanalytics.com/blog/connecting-quickbooks-online-to-power-bi-desktop/
- mgb-nav-pbi5 years agoAdvocate I
Thank you for your post. The "Script Error" is still there no matter what. I have edge, followed everything in your post but it does not work. Will have to wait for the long term Solution I guess!!!
- Sohrab5 years agoAdvocate II
If the "Script Error" icon looks like the IE11 one in the attached screenshot, it suggests that either Edge BETA isn't detecting a match when Power BI Desktop tries to connect. Which Quickbooks connector are you using, the one from the UI, or Quickbooks.Tables() ? If the latter, you'll need to use the method from my blog post - again, note that the variable value in that scenario is case sensitive!
It might also be worth confirming that you're running the current (Dec 2020) version of Power BI Desktop. You can also try with a new PBIX file, and just add the connection to QuickBooks via the GUI (with Edge BETA and the environment variable as described in the Microsoft documentation) to see if that gets you any further - that worked for me.
- BHobgood5 years agoFrequent Visitor
You were correct I didn't have the beta build installed... once I installed the beta build I was able to login. The new quickbooks connector for some reason doesn't provide access to General Ledger tables but the legacy Quickbooks.Tables() does but I haven't been able to login using that connector. Going to check out your post above now.