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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
WouterBo
Helper II
Helper II

fetchMoreData with dataReductionAlgorithm set to window in categorical dataview results in error

Hi,

 

I'm attempting to fetch more than 30K rows of data in a custom visual using a categorical dataview. I'm using the 3.4.0 API. Using the example by @dm-p which uses a tableview it seems to work fine. However, in my categorical dataview PowerBI produces an error message saying "can't display visual"..try again later.

 

My dataViewMappings in capabilities.json look like this:

 

 

 

"dataViewMappings": [
        {
            "conditions": [
                {
                    "value": {
                        "max": 1
                    },
                    "category": {
                        "max": 1
                    },
                    "details": {
                        "max": 1
                    }
                }
            ],
            "categorical": {
                "categories": {
                    "for": {
                        "in": "category"
                    },
                    "dataReductionAlgorithm": {
                        "top": {
                            "count": 1000
                        }
                    }
                },
                "values": {
                    "group": {
                        "by": "details",
                        "select": [
                            {
                                "bind": {
                                    "to": "value"
                                }
                            },
                            {
                                "bind": {
                                    "to": "tooltips"
                                }
                            }
                        ],
                        "dataReductionAlgorithm": {
                            "window": {
                                "count": 30000
                            }
                        }
                    }
                }
            }
        }
    ],

 

 

 

 

As you can see, the categories are limited to 1000. But the values are grouped by a details field and set to a "window" of 30K. As soon as the user provides the details field, the visual fails with PowerBI giving me the message "Can't display visual".

I realise that the window will apply to the result of aggregation of the data, but it feels like PowerBI doesn't like it. What am I not understanding?

 

Hope someone can help.

 

Thanks!

 

1 REPLY 1
WouterBo
Helper II
Helper II

So far, I've found that in a Categorical dataview only the categories can have a "window" dataReductionAlgorithm and the values (and eventual group by data fields) should not. They are the ones that result in either "Can't display the visual" or other behaviour. 
It appears as though I can "window" the categories, but the corresponding values are still limited to 30.000 values max.
Any expert insights are appreciated!

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.