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

[nandukrishnavs]

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

[milankRaj]

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

[v-qiuyu-msft]

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 

[nandukrishnavs]

Hi @v-qiuyu-msft,

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

[v-qiuyu-msft]

Hi @nandukrishnavs,

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

Best Regards,
Qiuyun Yu