dataviewmapping dataReductionAlgorithm not increasing number of rows inputted

[Anonymous]

  "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

[ripach · Accepted solution]

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-algorit... 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

[Anonymous]

Ah great spot thanks @ripach !