Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Get all data in custom visual using dataReductionAlgorithm in the matrix data mapping

We are trying to use dataReductionAlgorithm to fetch 30000 rows. However, the code is still returning the default limit of 1000 records. Please see the capabilities.json below.

Note: We have not added data-role for the column as we don't need it.

 

{
    "dataRoles": [
        {
            "displayName""Levels",
            "name""category",
            "kind""Grouping"
        },
        {
            "displayName""Details",
            "name""measure",
            "kind""Measure"
        }
    ],
    "objects": {},
    "dataViewMappings": [
        {
            "matrix":{
                "rows": {
                    "for":{
                        "to":"Levels"
                    },
                    "dataReductionAlgorithm": { "top": { "count": 30000 } }
                },
                "values": {
                    "for":{
                        "to":"Details"
                    }
                }
            }
        }
    ]
}


We are not using fetchMoreData as we wanted to fetch 30000 rows before pulling more than 30000.

Can you please help me with this?

 

Status: New
Comments
v-chuncz-msft
Community Support

@SonaliDhotre 

 

You may check for...in defined in Data view mappings and visit Custom Visuals Development Discussion for assistance.

SonaliDhotre
Advocate I

@v-chuncz-msft  I have gone through the documentation

 

Following is mentioned for matrix data mapping,


You can apply the data reduction algorithm to the rows and columns sections of the Data View mapping matrix.

and as I have mentioned above we have only rows dataRole so I have added the data reduction algorithm in the rows dataRole only(please check our capabilities.json above).

I have also checked on the forum for the solution.

Is there something I am missing or doing wrong?