I am creating the custom visual for powerBi and facing problem of 30000 limit.

[amitsangal78]

I am working on custom visual of venn diagram because it is not provided by powerBi itself. But Facing Issue because of my data have 1 million rows and I am getting only 30000(maximum). Because of this limitation my visual is always rendering wrong.

Is I am doing somthing wrong in capabilities json please have a look below. Please help I am struck badly.

{
"dataRoles": [
{
"displayName": "SetA Data",
"name": "setA",
"kind": "Grouping"
},
{
"displayName": "SetB Data",
"name": "setB",
"kind": "Grouping"
},
{
"displayName": "Criteria Data",
"name": "criteria",
"kind": "Grouping"
}
],
"dataViewMappings": [
{
"categorical": {
"categories": {
"select": [
{ "for": { "in": "setA" } },
{ "for": { "in": "setB" } },
{ "for": { "in": "criteria" } }
],
"dataReductionAlgorithm": {
"top": {
"count": 100000
}
}
}
}
}
]
}

Thanks for any kind of help in advance.

[v-chuncz-msft · Accepted solution]

@amitsangal78,

As mentioned here, you can modify the 'count' value to any integer value up to 30000. R-based custom visuals can support up to 150000 rows.

[amitsangal78]

@v-chuncz-msft

Thanks for your help.

But I am using d3.js for creating custom visuals for PowerBi. Is there any work around for these type of custom visuals.

[v-chuncz-msft]

@amitsangal78,

So far, no way available yet.

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

[amitsangal78]

@v-chuncz-msft

Thanks for help.

Is there any other work around using dax or using filters.

[v-chuncz-msft]

@amitsangal78,

Anyway, you may try to reduce the loaded dataPoints.