PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,906 questions
Power Query not importing all the Columns in a Worksheet
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 93%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
WestE
5
Reputation points
Hi, I'm using the Powerquery formula Excel.Workbook (File.Content) to connect to a folder that has a excel file with several worksheets in it. I'm then selecting the worksheet that I need to clean and get the required information to load in a Table. The worksheet has about 10 columns but somehow, just the 1st column is showing up. I've tried to see if may be the other columns were outside the print range but that wasn't the case.
Can anyone advise why I'm not able to import all the columns in that worksheet? Note that the data is not in Excel Table.
Sign in to answer