Forum Discussion
Quickbooks Online Authentication Error
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
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?
Yes, hopefully they find a work around pretty soon. This is pretty disappointing, and my reporting is completly dependant as well.
Anonymous
I've also been exploring a data warehouse solution. Let us know if you find something that works well.
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.
Sooo...over two weeks and no update. So am I to take that as my reports won't be useful until March of 2021?
