DataViewMappings with both table and categorical.

[michal089]

Hi!

Lately I came across the situation in which I have to define two different data view mappings. Being precise, I have to define both table and categorical mappings.

My code is:

    "dataViewMappings": [
        {
            "table": {
                "rows": {
                    "for": {
                        "in": "branches"
                    }
                }
            },
            "categorical": {
                "categories": {
                    "for": { "in": "category" }
                },
                "values": {
                    "select": [
                        { "bind": { "to": "value" } }
                    ]
                }
            }
        }
    ]

But that code won't compile :

 error  JSON  capabilities.json :  instance.dataViewMappings[0] is not exactly one from [subschema 0],[subschema 1],[subschema 2],[subschema 3],[subschema 4]

What am I doing wrong ?

Edit1:

I tried to create two dataViewMappings but for some reason my visual has crashed:

    "dataViewMappings": [
        {
            "table": {
                "rows": {   
                    "select": [
                        {
                            "for": {
                                "in": "measure1"
                            }  
                        },
                        {
                            "for": {
                                "in": "measure2"
                            }  
                        }
                    ]
                }
            }
        },
        {
            "categorical": {
                "categories": {
                    "for": {
                        "in": "categories"
                    }
                },
                "values": {
                    "select": [
                        {"bind": {
                            "to": "values"
                        }}
                    ]
                }
            }
        }
    ]

It seems that pbiviz does not support multiple queries. Anyone tried to create more then one dataViewMapping?

Any help would be much appreciated. 

Michal

[sauurabh]

Can i create two dataview objects for a single pbiviz project?

[akshaytech9]

Hi @v-viig,

Adding to the question raised by @rahulvartak, could you please let us know whether any single calculated measure value can be passed along with categorical dataview with many-to-one join relationship ?

Thanks,

Akshay

[Nafferty · Accepted solution]

Multiple dataViewMappings are not supported currently, which is a pain. I've basically been creating larger than necessary data tables in my model and passing those in, and then transforming the data into the format I need in my JavaScript before rendering my visuals.

https://github.com/Microsoft/PowerBI-visuals/issues/251

[v-viig]

No plans to support multi-data mapping. Please use one mapping (e.g. table or categorical).

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[rahulvartak]

Hi Ignat,

If I want to pass the value of a single calculated measure along with my categorical dataview, is it possible ?

Thanks & Regards,

Rahul