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]

Hey, 

The capabilities.json file require some parts even if they are empty:

• dataRoles
• dataViewMappings
• objects
• privileges

{
    "dataRoles": [
        {
            "displayName": "dbId",
            "name": "dbid",
            "kind": "Grouping"
        },
        {
            "displayName": "URN",
            "name": "urn",
            "kind": "Measure"
        }
    ],
    "dataViewMappings": [
        {
            "table": {
                "rows": {
                    "for": {
                        "in": "dbid"
                    }
                }
            },
            "single": {
                "role": "urn"
            }
        }
    ],
    "objects" : [],
    "privileges" : []
}

You should try it out.

If you wanna have fun you can watch the schema of a capabilities.json file 🤒 powerbi-visuals-api/schema.capabilities.json at main · microsoft/powerbi-visuals-api (github.com)

Maybe it won't work so please provide information about when and where does this error happen (when you start the custom, in the console etc...)

Thanks, have a good day