Forum Discussion

bertel's avatar
bertel
Regular Visitor
8 years ago

QBO

I get the following after connecting Power BI into QBO.     The query referenced a relationship between 'GeneralLedger'[Account] and 'Accounts'[AccountKey], which depends on a column that is not in...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

bertel,

Please connect to QuickBooks Online PBIT file in Power BI Desktop, then check if the columns in your table are defined in correct data type.

Regards,
Lydia

  • bertel's avatar
    bertel
    Regular Visitor
    8 years ago

    So tryng to work through this and understand PBI a little better I was able to pull this error.  Found the Hidden items.

     

    Error Message:
    The query referenced calculated column 'Accounts'[AccountKey] which does not hold any data because evaluation of one of the rows caused an error.

     

    It appears that the AccoutnKey is corrupt.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      bertel,

      Please check that if the AccountKey column contains any invalid values and if the calculations that using AccountKey column are valid.

      Regards,
      Lydia

      • bertel's avatar
        bertel
        Regular Visitor
        8 years ago

        Sorry Lydia, I am not sure exactly how to do that.  I will poke around some more to see what I can find.