I have connected Power BI to Quickbooks multiple times as a Power BI consultant. I have developed my own script to do this which has multiple benefits over the native connector:
- You can extract data from multiple QBO accounts and combine it together (relevant for owners of multiple businesses and accountants)
- 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 address removed]