cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
SolMercer
Level 1

Product/Service to Sales Inv links in QB Tables for Power BI

When linking to the quickbooks tables thru power bi, what tables create the link between sales invoice and product/service, and what is the unique identifier if required. I want to show sales invoices with individual lines for, or grouped by, product/service. The product/service field is available when editing a sales invoice.

2 Comments 2
KlentB
Moderator

Product/Service to Sales Inv links in QB Tables for Power BI

Thanks for checking out the Community space, SolMercer.

 

Let me share some information about the Power Bi integration.

 

Microsoft Power Bi controls how the data will be displayed for up-to-date visual analysis and reporting. It also automatically creates a dataset, report, and dashboard. The built-in dashboard shows current cash on hand, profit and loss trend, net income, top customers, and more. 

 

To ensure that you'll get accurate answers to your questions, I'd recommend contacting their support provider. You can get their contact details from this link: https://quickbooks.intuit.com/app/apps/appdetails/powerbi/en-us/.

 

If you need some resources while working with your sales transactions, you can browse some topics from our Help Article page.

 

If you need more help in syncing your other applications with QuickBooks, just add a reply below. I'll always have your back. Have a nice day.

Fiat Lux - ASIA
Level 15

Product/Service to Sales Inv links in QB Tables for Power BI

@SolMercer 

Another option, explore this connector

https://www.make.com/en/register?pc=quickbooks