Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Can i create two dataview objects for a single pbiviz project?
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |