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

  • julsh41's avatar
    julsh41
    Helper II
    5 years ago

    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's avatar
      ZGTX
      Frequent Visitor
      5 years ago

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

      • julsh41's avatar
        julsh41
        Helper II
        5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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?