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...
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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      bertel,

      Could you please share PBIX file for me to test? You can share PBIX file via Private Message.

      Regards,
      Lydia