While I was trying to load an excel which contians 750 column but was able to load only 255. Remaining are not showing up.
Me too facing the same issue when i am trying to upload an excel file with 350+ columns.
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
Thanks for the reply. We are trying import data from .xlsb workbook.
As the blog mentioned in my previous post, it's the limitation for .xlsb workbooks.