Forum Discussion
Solved
Power query limit columns?
Hi I'm trying to load an excel with about 400 columns 😱 No ideal ... Power query only loads up to about 200 colums. I found this on the microsoft power query limitations page Number of column...
Solved. It was an .xlsb, binary doc.
Out of curiosity if you delete that specific column does it work?
Are there any privacy settings on the missing colums that are different from the initial 200?
Solved. It was an .xlsb, binary doc.