Column Limit Exceeded

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.