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. 

Comments
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