Context

You have a workbook with a sheet with multiple columns:

Problem

You get only the first column when loading Excel workbook data into Power Query with Excel.Workbook function.

You get the following code when using the user interface options to import a workbook into PQ:

Notice the source is defined as follows:

= Excel.Workbook(Parameter4 , null, true)

The result (with a particular kind of Excel worksheet) is this:

Solution

Use the parameters of the Excel.Workbook where you can infer the sheet dimensions

= Excel.Workbook(Parameter4, [UseHeaders = false, DelayTypes = true, InferSheetDimensions = true])

Result

All columns are loaded correctly