formatting - capabilities.json

[tomdenby]

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

[Anonymous · Accepted solution]

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.