cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

Status: New
Comments
New Member

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

Moderator

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 

Frequent Visitor

Hi @v-qiuyu-msft,

 

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

Moderator

Hi @nandukrishnavs,

 

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

 

Best Regards,
Qiuyun Yu