Forum Discussion
Get all columns in custom visual
Master_T not sure it would be useful to you, but I'd suggest to investigate default matrix behavior and compare it to your custom visual. You can check what queries are sent to the storage engine and find patterns.
Eugene.
I don't know if the vague/evasive answers in this thread are because I didn't explain myself well (sorry in that case) or what, but I searched far and wide and I didn't find a way to overcome this limitation of the API. A limitation that is quite bizzarre to me, why arbitrarily limit the number of columns I can fetch in a professional BI product? I wonder if PoweBI Premium also has this limitation and this is a subtle way to "nudge" users into upgrading...
At any rate, in the end I had to use a normal table, instead of a matrix, I then had to write code to group the fields and compute the data aggregates myself, basically rebuilding the matrix in code from the linear table data... which again, is a ridiculous thing to do in a professional BI product, but I couldn't find any way around it.