Only select certain columns from source

it it possible to add all of those, but they need to be added *before* the column selection. the code that i wrote above serves as the *core* of your data source. so you will need to have that as the origin. I will give an example:

let
// Define source
Source = OData.Feed("your link", null, [Implementation="2.0"]),

// What to select
Table = 
      // Sort by 
         Table.Sort(
              // Select rows

                   Table.SelectRows(
                        // Select columns

                           Table.SelectColumns(Source{[Name="Your table name", Signature="table"]}[Data],
                                   {"Column 1", "Column 2", "Column 3", "Column 4", "Column 5"}

                            ),

                     each [Column 1] = "X"  and [Column 2] = "Y" 

                   ),
          {{"Column 1", Order.Ascending}}

         )

as table

in 

Table

I highlighted the source in bold. All of these table.(select) functions require a table as the first argument. this table is given by the highlighted part in the code. this is what i mean as the *origin*. In this way, you select the source with the columns you want, and then apply a cascade of filtering, transformations, etc, without having to repeat the source for each table. function. If you want to add another transformation, you would add it before the Table.Sort. Might not be the most logical way to do it, but it works just fine in my case.

Here is an article I wrote last year that may help you get started with using OData.  It includes examples of adding $select and other ways to let you limit the initial amount of data returned. 

https://powerpivotpro.com/2019/02/some-odata-tips/

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat