cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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!

 

 

 

20 REPLIES 20
Frequent Visitor

@GreyDuck Thanks for the update. Keep us posted.

Highlighted
Helper II
Helper II

Still no luck getting QBO data refreshed in Power BI Desktop.  Anyone heard any updates on getting this fixed?

Highlighted

Hi all,

 

@julsh41  looks like they've updated this to a global issue on the PBI support dashboard.

https://powerbi.microsoft.com/en-us/support/

 

Estimates on a resolution estimate is due to be delivered today.

I'll update the post as I confirm that the issue is resolved on my end.

 

Edit* New eta for a fix is 9/23

image.png

Highlighted

Looks like maybe no fix until March 2021? Hopefully a workaround sooner. Anyone have any ideas for solving this? My whole reporting process depends on QBO.

 

How hard is it to set up a Stitch to AWS-type sync? Any one have any other ideas?

 

dizzygoldfish_0-1600953339035.png

 

Highlighted

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

Highlighted
Advocate II
Advocate II

Hi all,

 

Update as of 9/24:

 

GreyDuck_0-1600955059422.png

 

Looks like we no longer have an eta for the short term fix and a long term fix set to be put in place 3/31/21.

This update is deeply frustrating for those of us with production dashboards and reports that rely on this data.


If anyone is interested in a hosted solution, please feel free to reach out to me at contact@runwayanalytics.com

Highlighted

@dizzygoldfish 

I've also been exploring a data warehouse solution. Let us know if you find something that works well.

Highlighted

@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.

Highlighted

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

Highlighted
Frequent Visitor

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors