Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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?
Solved! Go to 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
Proud to be a Super User!
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
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
Proud to be a Super User!
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
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 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.
User | Count |
---|---|
10 | |
5 | |
4 | |
4 | |
3 |
User | Count |
---|---|
13 | |
9 | |
5 | |
5 | |
4 |