Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Quickbooks oauth screen in Power BI hangs after successful Quickbooks login - no script errors

Submitted by Anonymous on ‎10-06-2020 09:12 AM

The Support page shows an open issue with the Quickbooks connector on Desktop.  I'm entering this as a new issue because the outcome I'm receiving (described below) doesn't match the outcome described on the page (script error).  If what I'm experiencing is confirmed to be the same issue then please merge this with the existing issue.

 

After being prompted that the production dashboard's Quickbooks credentials are no longer valid, I selected the option to sign into Quickbooks.  After the Quickbooks username and password is accepted, the following screen (https://appcenter.intuit.com/app/connect/oath2) is displayed and remains showing empty data:brian_samson_0-1601999558240.png

This is using the standard Quickbooks connector that ships with the Desktop tool.  I've used the Quickbooks connector for the past 11 months without issue.  I've also confirmed that the Quickbooks login information is correct and accepted because entering an invalid password doesn't allow me to move past the QB login screen.  

 

Power BI Version: 2.85.985.0 64-bit (September 2020)

Power BI Pro User

Status: New
See more ideas labeled with:
5 Comments (5 New)
Comments
JohnJackson
New Member
‎10-06-2020 05:52 PM

I have the same issue. I hope this is fixed soon as I am having to do the reports in excel for now.

Sohrab
Helper I
Helper I
‎01-14-2021 10:53 AM

There is an update as of today.  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/

syntrixsystems
Frequent Visitor
‎01-22-2021 07:22 AM

*edit* - I thought the version of edge I had installed by default was the same as what you mentioned above but apparently not. I downloaded the beta and now can connect without error.  Thanks.

 

Sohrab
Helper I
Helper I
‎01-22-2021 07:29 AM

@syntrixsystems sorry to hear that the technique I mentioned might not be working for you. At first glance, those script error screenshots look like they are the "old IE11" style script boxes.  Check that you installed the *Beta* version of Edge which supports the new environment variables. Note from my blog post, the last screenshot that shows the QBO login screen, the icon at the top left of the dialog looks something like the "windows script host" dialogs - not like an IE11 window.

henrylamyf
New Member
‎02-08-2021 12:33 PM

@Sohrab want to thank you for your instructions on Jan 14, 2021. This solved my problem! Cheers

Idea Statuses