Forum Discussion

tomdenby's avatar
tomdenby
Frequent Visitor
2 years ago
Solved

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],[subsc...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.