Forum Discussion
Quickbooks P&L problem
Hi everybody,
I've been using PowerBI Desktop with Quickbooks for a few weeks now. I've watched numerous videos on LinkedIn Learn and YouTube, but somehow it just doesn't work. I can't see my P&L data in any of the queries. Can someone please help me out?
When I hit the "get data" button and choose for Quickbooks, I get around 113 queries, I've chosen all of them and went through them one by one. I also added the GL query manually (found that in another post) but it still doesn't work.
Can someone please explain me how to get a P&L report? 🙂
Kind regards,
Ismail
2 Replies
Hi IsmailWR ,
I found some articles about how to connect to quickbooks, maybe helpful, you can refer.
QuickBooks Power BI Integration: 2 Easy Methods - Learn | Hevo (hevodata.com)
Power BI and QuickBooks Online: Finances Made Simple | Microsoft Power BI Blog | Microsoft Power BI
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I faced this problem before and this is why I created my own code to extract QBO data into Power BI. All P&L data is combined in a single table. You can also drill down to transactions that make up value of every account, filter by day and see data on accrual vs cash basis. Same for Balance Sheet, Cash Flow, Account Receivables, Budget, etc.
Here is more info about it: https://vidi-corp.com/how-to-connect-power-bi-to-quickbooks-online-reports/My email is [email protected]
