Select Columns from OData Feed

[Anonymous]

I'm looking for a way to reduce the number of columns this Odata feed is bringing in. Once I select my User Data table, it's pulling in over 2000 columns, making powerQ very slow. 

I know I can, remove other columns once they are in Power Q but I was wondering if there's any way to update Advanced editor so it only brings in the following columns:
"ID"
"RefNumber"
"FullName"
"CreatedDate"

Advanced Editor

let
Source = OData.Feed("ODataURL", [#"X-API-Token"=#"Key"], [Implementation="2.0"]),
Users_table = Source{[Name="Users",Signature="table"]}[Data]
in
Users_table

[DnsLeu]

Hello!

Check my answer to a similar question. 

Best regards,
Denis

[v-kelly-msft]

Hi  @Anonymous ,

Add a query in your expression:

let
Source = OData.Feed("ODataURL", [#"X-API-Token"=#"Key"], [Implementation="2.0"]),
Users_table = Source{[Name="Users",Signature="table"]}[Data]
#"Column"=Table.SelectColumns(Users_table,{"ID","RefNumber","FullName","CreatedDate"})
in
#"Column"

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[CNENFRNL]

@Anonymous , from syntactic perspective, OData Feed connector features the functionality of passing query paramters to the requested url. You might want to try after referring to the documentation of the requested uri.