Forum Discussion
Possibility of exceeding value "dataReductionAlgorithm" from capabilities.json
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?
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
4 Replies
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 dm-p,
It works, thank you so much for your help and brilliant solution.
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.
