Forum Discussion

Master_T's avatar
Master_T
Helper I
5 years ago

Get all columns in custom visual

I'm trying to build a custom pivot table visual for PowerBI, and to do that I'm using the "matrix" dataview mapping, like this:     "dataRoles": [ { "name": "Category", ...
Need Help
jprdynamicapps's avatar
jprdynamicapps
Helper IV
4 years ago

I'm working on the same issue with my custom matrix visual. I get 10 columns back even though there are more values in the column list. In previous PBI versions, I didn't get any warning, but in the current version, I get the "Too many [column] values" message.

FYI, the "Simple Matrix" visual at https://github.com/microsoft/Powerbi-Visuals-SampleMatrix does not exhibit this problem, so I'll be looking at the differences between mine and that re data mapping configuration and the traversal/fetch more data code that I have. Will post back if I solve it.

Master_T's avatar
Master_T
Helper I
3 years ago

That is interesting, have you discovered anything further? I will keep this in mind in the future if I need to use pivoted data again.

  • jprdynamicapps's avatar
    jprdynamicapps
    Helper IV
    3 years ago

    Sorry, it ended up elsewhere in the thread instead of as a reply to this message.

     

    I was able to resolve the problem by adding the same data reduction algorithm setting to columns. No clue why I have to set that in order to get more than 10 columns, but it worked. I believe the default for rows is 1000. Maybe the default for columns is 10?