cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Re: What is the maximum number of columns Power BI Desktop allows?

hum, ok. You mean the Matrix visual object, at first I thought it was the data table itself. My bad. In this case, I think it is a limitation of the object, and I don´t know any solution on this case. Maybe you can try to get a new custom visual, but the appearance of the new visual will be slightly different. How many levels of drilldown do you have? Maybe if you lower the quantity of drilldowns it may improve the visual, idk.

alforc1 Frequent Visitor
Frequent Visitor

Re: What is the maximum number of columns Power BI Desktop allows?

Hi Thanks again for coming back to me. 

 

I have 4 levels of drilldown in place currently.  I will try both solutions that you have suggested.  Again thanks for the feedback.

 

 

AdamBoltryk Regular Visitor
Regular Visitor

Re: What is the maximum number of columns Power BI Desktop allows?

Hi All, I can confirm to limit of column displayed in visual. In my case when I created table with week numbers in columns I've got table from WK01|16 till WK08|18. It's mean (simple math) 52+52+8 = 112 columns Smiley Happy 

ChrisHaas Established Member
Established Member

Re: What is the maximum number of columns Power BI Desktop allows?

https://support.office.com/en-us/article/power-query-specifications-and-limits-5fb2807c-1b16-4257-aa...

 

This document shows the Column limit for Power Query is 16,384...in line with some of the other comments on this thread of "Power BI complaining about 16,000 columns"

AdamBoltryk Regular Visitor
Regular Visitor

Re: What is the maximum number of columns Power BI Desktop allows?

Hi Chris,

Quote:

'... when I display in a Matrix it will only display around 104 columns it then stops showing any columns after that point...'

End of quote.
I think he asked for limitation in VISUAL, not the data table. And my answer related to this question.

 

Regards,

Adam

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 51 members 1,008 guests
Please welcome our newest community members: