Forum Discussion

Black783's avatar
Black783
Frequent Visitor
9 years ago

QuickBooks Connection Duplicate Invoice Records

When a QuicBooks Online Invoice has Sales Tax and Shipping values assoicated with it, there are 3 records assoicated with that invoice on the Invoice table.  The line item amount and Sales tax amount...
Need Help
Black783's avatar
Black783
Frequent Visitor
9 years ago

Appreciate the assistance but this approach would require an excessive amount of measures.  An invoice can have many line items with references and assoicated amounts so you have to develop a measure for each one plus sales tax, freight, etc. 

 

Also I'm not sure you can write an IF statement to get the proper results.

 

It seems to me that the data set from the QuickBooks connection is flawed.  If I was extracting from SQL Server, I would have individual records for each line item, freight, and sales tax. 

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Black783,

It seems to me that the data set from the QuickBooks connection is flawed.  If I was extracting from SQL Server, I would have individual records for each line item, freight, and sales tax. 

QuickBooks Online connector is still a preview connector, and is still under development currently.

 

 

Could you submit your requirement on Power BI Ideas and vote it up to improve Power BI and make it better?:smileyhappy:

 

Regards

  • Black783's avatar
    Black783
    Frequent Visitor
    9 years ago

    I will submit.