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 a valid state

 

I have tried attaching the QBO Content Pack multiple times over the last month.  Always get the same error as above for most of the tiles.  If anyone has any ideas please let me know.

8 Replies

    • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    bertel,

    You can upload PBIX file to OneDrive, then send the shared link of the file via Private Message.

    Regards,
    Lydia

    • bertel's avatar
      bertel
      Regular Visitor
      8 years ago

      I am guessing that the issue can not be resolved?  Any update?  I truely appreciate the assistance.