QBO

[bertel]

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.

[Anonymous]

that works in my case, hope it helps too

https://stackoverflow.com/questions/38010256/converting-an-integer-to-a-text-value-in-power-bi

[Anonymous]

@bertel,

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

Regards,
Lydia

[bertel]

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

[Anonymous]

@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]

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]

@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]

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

[Anonymous]

@bertel,

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

Regards,
Lydia