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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.