Power query CDS feed select fields statement like you can with SQL?

[masplin]

Hi. I'm new ot using Odata and CDS conenctions but wondering if there is a way to just select given fields liek you can with an SQL query using SELECT and a list of field name from given DB? 

Currently I just have this that pulls every field then I remove most of the columns. seems very wasteful

let
Source = Cds.Entities("https://wxxxxxxxxxx.api.crm11.dynamics.com", [ReorderColumns=true, UseFormattedValue=true]),
entities = Source{[Group="entities"]}[Data],
acg_wtevents = entities{[EntitySetName="acg_wtevents"]}[Data]
in
acg_wtevents

Any advice appreciated

Mike

[mahoneypat]

It looks like you can use the web connector instead of Cds.Entities() and then use the OData protocol, which includes using $select to define the columns you want (I haven't done this yet but it looks doable).

Query Data using the Web API (Microsoft Dataverse) - Power Apps | Microsoft Docs

Pat

[masplin]

Ok so this bit might work for pulling certian fields 

GET [Organization URI]/api/data/v9.1/accounts?$select=name,revenue

i havenoidea howI use GET in Power Query, but will investigate

Thanks

i'm using the CDS because need ot extract the display vlaues of some fields insteadof numerical values. 

[lbendlin]

Web.Contents() does a GET unless you specify a data payload in which case it does a POST.

[v-lionel-msft]

Hi @masplin ,

This idea can not be realized in the PowerBI connector in current version. Try to get the columns you want directly from the data source (filter in the data source).

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

here's the ODATA query reference. Query options overview - OData | Microsoft Docs

[masplin]

I think the odata ref is about filtered the rows of date not controlling whihc fields to recover.  i have 50+ columns of data but only need 2 or 3 so seems a waste of resources. Seems a massive oversight?