Select query in odata v4 is ignored

Status: Accepted
by agur Frequent Visitor on ‎01-31-2018 04:16 AM

When using $select in the query string for an OData v4 service it is ignored.

For example:

= OData.Feed("https://<org>.api.crm4.dynamics.com/api/data/v8.2/opportunities?$select=name,actualrevenue")

This returns all opportunities with ALL fields, not only name and actualrevenue

 

= OData.Feed("https://graph.microsoft.com/v1.0/groups?$select=id")

This returns ALL fields, not only group ID

 

This has a HUGE business impact, as this makes loading data in PBI reports extremely slow. The consensus in the Dynamics 365 environment is to export the data to an Azure database before loading it into PBI, which breaks security hierarchy and makes everything less user friendly.

Status: Accepted
Comments
by v-jiascu-msft Super Contributor
on ‎02-02-2018 12:45 AM

Hi @agur,

 

I have reported this issue to the Product Team: CRI 58867358. I will post the updates here.

 

Best Regards,

Dale

by v-jiascu-msft Super Contributor
on ‎02-02-2018 01:00 AM

Hi @agur,

 

I have reported this issue to the Product Team: CRI 58867358. I will post updates here.

 

Best Regards,

Dale

by Moderator Vicky_Song
on ‎02-02-2018 01:04 AM
Status changed to: Accepted
 
by ergore New Member
on ‎02-02-2018 05:06 PM

Hello @agur,

For OData V4 endpoints, we currently do not support querying directly via OData URLs. We are investigating support for this, but it involves significant changes to our OData connector, and we do not have an ETA at this time. For now, the solution is to query using the Query Editor or M script. The M script in this case would be:

 

let Source = OData.Feed("https://graph.microsoft.com/v1.0"),
    Groups = Source{[Name = "groups"]}[Data],
    Selected = Table.SelectColumns(Groups, "id")
in
    Selected
Idea Statuses