Forum Discussion

GreyDuck's avatar
GreyDuck
Advocate II
5 years ago

Quickbooks Online Authentication Error

Hi all,   I'm working to query QBO data and reciving the errors below when attempting to login.     Choosing yes or no on each error message has no bearing on the outcome. ...
Need Help
julsh41's avatar
julsh41
Helper II
5 years ago

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

GreyDuck's avatar
GreyDuck
Advocate II
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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?

     

     

    • julsh41's avatar
      julsh41
      Helper II
      5 years ago

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

    • ZGTX's avatar
      ZGTX
      Frequent Visitor
      5 years ago

      Anonymous 

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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.