Power Query not importing all the Columns in a Worksheet

WestE 0 Reputation points
2024-03-07T04:20:59.11+00:00

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.

PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,007 questions
0 comments No comments
{count} votes