Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
GreyDuck
Advocate II
Advocate II

Quickbooks Online Authentication Error

Hi all,

 

I'm working to query QBO data and reciving the errors below when attempting to login.

GreyDuck_0-1599841884310.png

GreyDuck_1-1599842000094.pngGreyDuck_2-1599842020273.png

GreyDuck_3-1599842052230.png

 

 

Choosing yes or no on each error message has no bearing on the outcome. So far in order to trouble shoot this I've:

  1. Cleared all data source settings
  2. Reinstalled PBI with the lates version (Aug 2020)
  3. Confirmed my login works to access quickbooks on a web browser

I'm running out of ideas of what else to troubleshoot and all sugestions are welcome, Thanks!

 

 

 

37 REPLIES 37
Anonymous
Not applicable

@ZGTX 

I set up Stitch to connect in to QBO and it's working really well so far. I ended up with the same set of tables. I haven't started moving the PQ queries to point to the new source yet though. Doesn't look like it will be that difficult though.

 

I set Stitch up to replicate the QBO database every 30 minutes into our Amazon RDS Postgres database. I have no idea what all was involved on the Postgres side - our engineering team handled that. Since we already had an integration with another source set up it only took them a few minutes to get me up and running. Not sure how hard it would have been otherwise. Stitch seems to have things pretty well automated though.

 

One thing I ran into was fixing a weird certificate issue with AWS. Wasn't too bad to fix once I found this article: https://saurabha.com/connecting-power-bi-to-aws-rds-postgresql/

 

Good luck! Can't believe there's still not ETA for a fix! $100/mo to Stitch will end up being money well spent though.

Anonymous
Not applicable

Were you able to connect your Customer table to Journal Entries, Deposits, Purchases etc once you moved the data into Power BI?

I found that the connection between Customer and those other Tables worked with the Power BI connector, but have not found it yet using Stitch. I messaged their support team, but am awaiting a reply. Any thoughts?

 

Sooo...over two weeks and no update.  So am I to take that as my reports won't be useful until March of 2021?

ZGTX
Frequent Visitor

Received an update from my Microsoft support case that there is still not ETA for a resolution.

Doesn't feel like it is being worked on...disappointing but thanks for the update

Yes, hopefully they find a work around pretty soon.  This is pretty disappointing, and my reporting is completly dependant as well.  

GreyDuck
Advocate II
Advocate II

Update as of 9/17/2020:

 

Met with Microsoft support and they've documented the issue with error logs and fiddler traces.

The issue has be escalated with the product team and I'm awaiting to hear next steps.

 

Other troubleshooting steps taken with no effect:

  • Set default browser to firefox (thanks @ZGTX  for the idea)
  • Uninstalled ie
ZGTX
Frequent Visitor

@GreyDuck Thanks for the update. Keep us posted.

BHobgood
Frequent Visitor

I am getting the same error when trying to connect to quickbooks online. I've performed the same troubleshooting steps with no luck. 

ZGTX
Frequent Visitor

Not a solution, but maybe why we're having an issue. Looks like intuit is not supporting IE or Edge as embedded browers.

 

Found these two posts. 

https://docs.microsoft.com/en-us/power-query/connectors/quickbooksonline

https://blogs.intuit.com/blog/2020/06/27/alert-support-for-ie11-deprecating-on-july-31-2020-for-auth...

 

ZGTX
Frequent Visitor

Any updates? I'm having the same issues

Greg_Deckler
Super User
Super User

@GreyDuck What connector are you using and what authentication type?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler,

 

I'm using the default connector found in the get data menu.

GreyDuck_0-1599843657544.png

 

 

I belive the authentication type is Oauth 2.

 

 

@GreyDuck You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler  will do!

Thank you for the help and direction!

Hello...any update here?  Is there a resolution on the way?  I am getting the same issue.

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/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.