Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.
Web.Contents() does a GET unless you specify a data payload in which case it does a POST.
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.
here's the ODATA query reference. Query options overview - OData | Microsoft Docs
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |