Forum Discussion
Possibility of exceeding value "dataReductionAlgorithm" from capabilities.json
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
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.jsonfile. For example:"dataReductionAlgorithm": { "window": { "count": 30000 } }Note that if you use
windowas I did in the code (instead oftop,bottom, orsample), you will be also able to use the Fetch more data feature to bypass the 30K rows limit.
Data reduction algorithm usage
Best Regards
Thank you so much for your idea 😍
I will investigate this way.
