Forum Discussion
formatting - capabilities.json
The following formatting gives me this error - gets the following error error JSON capabilities.json : instance.dataViewMappings[0] is not exactly one from [subschema 0],[subschema 1],[subschema 2],[subschema 3],[subschema 4]
{ "dataRoles": [ { "displayName": "dbId", "name": "dbid", "kind": "Grouping" }, { "displayName": "URN", "name": "urn", "kind": "Measure" } ], "dataViewMappings": [ { "table": { "rows": { "for": { "in": "dbid" } } }, "single": { "role": "urn" } } ] }
Im sure it is a basic formatting issue but I can’t figure it out, would someone be able to advise ?
Thanks Tom
Hi Rugilė ,
According to the error description, this indicates that the configuration instance does not match the Json format. I modified this code to add a column section to the table property indicating that the column should contain the "urn" role.
{ "dataRoles": [ { "displayName": "dbId", "name": "dbid", "kind": "Grouping" }, { "displayName": "URN", "name": "urn", "kind": "Measure" } ], "dataViewMappings": [ { "table": { "rows": { "for": { "in": "dbid" } }, "columns": { "for": { "in": "urn" } } } } ] }Refer to:
Understand data view mapping in Power BI visuals - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Rugilė ,
According to the error description, this indicates that the configuration instance does not match the Json format. I modified this code to add a column section to the table property indicating that the column should contain the "urn" role.
{ "dataRoles": [ { "displayName": "dbId", "name": "dbid", "kind": "Grouping" }, { "displayName": "URN", "name": "urn", "kind": "Measure" } ], "dataViewMappings": [ { "table": { "rows": { "for": { "in": "dbid" } }, "columns": { "for": { "in": "urn" } } } } ] }Refer to:
Understand data view mapping in Power BI visuals - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.