Design Properties Connector - Navigation/Field Error

[amy-eliz-williams]

I've successfully built the .mez file for the Design Properties Connector, but when attempting to pull in data from the connector, I am receiving the following:

Expression.Error: The field 'derivatives' of the record wasn't found.
Details:
item=[Record]
links=[Record]
refs=[Record]
downloadFormats=[Record]

This occurs with any Document within my project files and these versions/derivatives appear correctly via the APS VSCode Extension.

Additionally, when navigating the table view within PowerQuery, the Name column produces the following error:

Expression.Error: 1 arguments were passed to a function which expects between 2 and 3.
Details:
Pattern=
Arguments=[List]

I've identified that the Name column is produced from GetItemVersions > GetVersionDetails within DataManagement.pqm passing to GetItemVersionNavigationTable in DesignPropsConnector.pq; given the version name is not being produced, and the derivatives field is not being found, I am assuming there is an issue with acquiring the item version from the document, but I'm not sure how to resolve (this could definitely be an experience issue and not an issue with the code!) Thank you!

[yiskang]

@amy-eliz-williams I'm sorry to hear this issue is bothering you, but I didn't find a table similar to the one you showed above.

Looking at https://github.com/autodesk-platform-services/aps-powerbi-tools/blob/develop/connectors/DesignPropsConnector/DesignPropsConnector.pq#L104, probably, one of your version data has no attribute called derivative. If so, you could try to add an empty value check there. For example: https://community.fabric.microsoft.com/t5/Desktop/Handling-empty-rows-cells-in-JSON-Power-BI-Quering/m-p/458267

If you have further questions on Power BI Query, please consult the Power BI community instead, as this repo is a sample for demonstrating the possibilities of integrating APS API within PowerBI.

Our apologies for the inconvenience!