Column Limit Exceeded

[fayanan]

I have a dataset with 27 columns. Whenever I try to load it, it says that "The total number of columns in the model is 16414, which exceeds the limit of 16000." See below screenshot. How do I work around this?

[v-angzheng-msft · Accepted solution]

Hi, @fayanan 

16,000 is the maximum amount of columns.

If you want to know more about that, you can refer to below link: Data sources for the Power BI service

There are only 27 columns in your data set, which obviously does not exceed the column limit.
Please check if there is a conflict between the names of your worksheet and the table.

If you have a tbale name with the same name as you sheet, when connect to this excel file, Power BI will rename your table name. It can cause this issue.

For reference:

Total number of columns exceeded (but data was not changed)

Error Msg : Column Exceeds 16000 limit but there are only 100 colmns in the excel table

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

If your source is an MS Excel file, then delete all columns after the last column.  Save and close the Excel file and retry.

[PowerBIBeginer]

This is correct. @Ashish_Mathur  just deleted columns even though its look like blanks..