topic Re: dataviewmapping dataReductionAlgorithm not increasing number of rows inputted in Custom Visuals Development Discussion

dataviewmapping dataReductionAlgorithm not increasing number of rows inputted

Anonymous — Sat, 23 Apr 2022 16:31:07 GMT

"dataViewMappings": [ { "table": { "rows": { "select": [ { "for": { "in": "column" } }, { "for": { "in": "value" } }, { "for": { "in": "value2" } }, { "for": { "in": "value3" } }, { "for": { "in": "value4" } }, { "for": { "in": "value5" } }, { "for": { "in": "value6" } } ] }, "dataReductionAlgorithm": { "top": { "count": 30000 } } } } ]

Ive added a datareduction to the first 30,000 but the visual still only brings in the first 1000 rows

Any thoughts to why are greatly appreciated

Re: dataviewmapping dataReductionAlgorithm not increasing number of rows inputted

ripach — Thu, 28 Apr 2022 11:37:02 GMT

Hi,

the dataReductionAlgorithm-setting should be applied to the rows object, not to the whole table (see https://docs.microsoft.com/de-de/power-bi/developer/visuals/dataview-mappings#data-reduction-algorithm-usage, there is also an example for tables at the bottom). Try moving it inside the rows object:

"dataViewMappings": [ { "table": { "rows": { "select": [ .... ], "dataReductionAlgorithm": { "top": { "count": 30000 } } } } } ]

Best regards,

Robert

Re: dataviewmapping dataReductionAlgorithm not increasing number of rows inputted

Anonymous — Thu, 28 Apr 2022 12:13:37 GMT

Ah great spot thanks @ripach !