Limit on the number of columns in Table and Matrix visuals

[Anonymous]

What is the limit on number of columns that are displayed in the table and matrix visuals in Power BI? 
Is it 255 columns or 500 columns? 
Which is number after which the visual will not let me scroll horizontally? 

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

As this post said, the matrix doesn't support so many columns. It seems to support up to 100 columns. It won't show all these column values.  As a workaround, you could consider insert a slicer to dynamically filter matrix columns.

https://community.powerbi.com/t5/Desktop/Too-many-values-Not-showing-all-data-in-Matrix/td-p/412759

Best Regards,

Lin

[Mehdi]

I can confirm as at this date 09/23/2021 the matrix visual is still limited to 100 columns.
I ended with this result as I added in the columns placeholder the a 'Day of Year' values from 1 to 365 but only the first 100 days have been shown.

[Anonymous]

Yes this is correct and I verified it today, they have to increase to 500 or something.

[Anonymous]

Hi kishanbhaip,

This is upto 1 GB of data can a visual holds. we can't say how many columns and records. It's upto the user but all together should be below 1 GB.

Regards,

Pradeep