I appreciate you for sharing some clarifications with us, @SolMercer.
I'll share some details about linking your QuickBooks Online (QBO) to Power BI.
When connecting your QBO account to Power BI, it'll automatically creates a dataset, report, and dashboard. This lets you visualize your finance data and uncover new insights about your cash flow.
To learn which table links your invoice and products and services in Power BI, I recommend contacting their support team. One of their live agents can look into your account and guide you through the process.
Once everything is set, you might want to read this article that can guide you in case you want to learn how to import data in QBO: Common questions about importing data to QuickBooks Online.
You can count on me if you need more help managing your QBO. Simply layout the details in your reply and I'll take care of them for you. Keep safe and have a great day ahead!
