Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Quickbooks Online Fields missing

Good day,

 

I am struggling with the Quickbooks Online tables in Power BI desktop.  The relationships are not apparent and it appears that some field data is missing.  Many fields contain [Record] or [List] as data.  For example, Customer Ref in the invoice table shows [Record].

For example, invoice table:

 

Id

SyncToken

MetaData

CustomField

DocNumber

TxnDate

DepartmentRef

CurrencyRef

ExchangeRate

PrivateNote

LinkedTxn

Line

TxnTaxDetail

CustomerRef

12376

2

[Record]

[List]

INV001366

14-May-18

 

[Record]

1

 

[List]

[List]

[Record]

[Record]

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Many thanksAssistance would be much appreciated.

Karen

Need Help

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    You can expand the [Record] and [List] to extract actual data from them.

     

    Regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks Yuliana, I can do this for one record at a time.  How do I expand all of these items for use in the original table?