Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
6 | |
4 | |
2 | |
2 |
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
3 |