Forum Discussion
Get all columns in custom visual
Hi Master_T ,
Please refer to the link.
Understand data view mapping in Power BI visuals
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry, but linking me the basic documentation on data view mappings doesn't really answer my question...
As I showed in the OP, the mapping configuration is correct, what I'm asking is how to retrieve ALL the data in the matrix when it exceeds the limit for a single data fetch, since the "fetchMoreData" API, from what I've discovered by testing, seems to only work in "table" mappings, it does nothing when called in "matrix" mappings.
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.