Unable to fully load excel which contains 750 columns in Power BI

Status: New
by nandukrishnavs Frequent Visitor on ‎11-27-2018 02:25 AM

While I was trying to load an excel which contians 750 column but was able to load only 255. Remaining are not showing up. 

by milankRaj New Member
on ‎11-27-2018 04:25 AM

Me too facing the same issue when i am trying to upload an excel file with 350+ columns.

by Moderator v-qiuyu-msft
on ‎11-27-2018 09:57 PM

Hi @nandukrishnavs@milankRaj


Is it .xls and .xlsb workbooks, or xlsx workbooks? There is a 255 columns limitation when importing data from .xls and .xlsb workbooks. See: https://support.office.com/en-us/article/power-query-specifications-and-limits-5fb2807c-1b16-4257-aa...


Best Regards,
Qiuyun Yu 

by nandukrishnavs Frequent Visitor
on ‎11-27-2018 10:05 PM

Hi @v-qiuyu-msft,


Thanks for the reply. We are trying import data from .xlsb workbook. 

by Moderator v-qiuyu-msft
on ‎12-04-2018 01:27 AM

Hi @nandukrishnavs,


As the blog mentioned in my previous post, it's the limitation for .xlsb workbooks. 


Best Regards,
Qiuyun Yu