Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Select Columns from OData Feed

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

Need Help

3 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    5 years ago

    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.

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    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!