cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

Highlighted
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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 135 members 1,696 guests
Please welcome our newest community members: