Forum Discussion
Quickbooks Online Authentication Error
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/
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!!!
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.
I am working with the Dec version of Power BI and this is what I got as seen in the snapshot.
Trying with the new file does not work too. Same Script Error. However, I took the long route as suggested by bmaupin and from Power BI Service I could login normally, refresh and download the pbix file.
I am still unable to refresh directly in PBI Desktop, but my QBO data does refresh sucessfully via PBI online. I have been publishing from PBI Desktop, refreshing the data in PBI Online, then downloading the updated PBIX file in order to view the latest data in Desktop. Not the most elegant work around, but we ulitmately present everything in PBI Online anyways and use Desktop to build.
Sure not an elegant way but worked for me as well. Thanks.
