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, r...
Need Help
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!