Possibility of exceeding value "dataReductionAlgorithm" from capabilities.json

[Roman-Korovets]

Hi there!

I have a limit of "9000" of rows inside capabilitys.json, however some users would like to have much more.

Unfortunately, I'm not able to change the value in "capabilitys.json" file.

I'm wondering if it is possible to create an option on format pane which allow user to set the own limit for rows

(bigger than value in capabilitys.json) 

@dm-p, could you help me with it? Or any idea? 

[dm-p · Accepted solution]

Hey @Roman-Korovets - sorry, I missed your tag. You can control the window size from the properties pane using the customized data reduction API. Note that the documentation doesn't state this but the example shows the exact object/property names (dataReductionCustomization.rowCount / dataReductionCustomization.columnCount) that you must use for this to work in a visual, as they seem to have been reserved by MS for this purpose; you can't put them anywhere in the properties pane. I initially tried using different property names and it didn't work for me that way.

Good luck!

Daniel

[Roman-Korovets]

Hi @dm-p,

It works, thank you so much for your help and brilliant solution.

[v-yiruan-msft]

Hi @Roman-Korovets ,

Base on my research, there is no option to dynamically change the dataReductionAlgorithm limit set in the capabilities.json file directly from the format pane of a Power BI custom visual. You need to modify it in capabilities.json file manually.

powerbi - How to change Data Point Limit of Power BI Custom Visual - Stack Overflow

You need to set the dataReductionAlgorithm property in the capabilities.json file. For example:

"dataReductionAlgorithm": {
    "window": {
        "count": 30000
    }
}

Note that if you use window as I did in the code (instead of top, bottom, or sample), you will be also able to use the Fetch more data feature to bypass the 30K rows limit.

---

Data reduction algorithm usage

PowerBI-visuals/Capabilities/DataViewMappings.md at master · PowerBi-Projects/PowerBI-visuals · GitH...

Best Regards

[Roman-Korovets]

Thank you so much for your idea 😍
I will investigate this way.