Forum Discussion
Solved
How to load only required columns
Dear community, we are building dashboards using CDS and Dynamics as data sources. We load tables like accounts, contacts, activitypointers and activityparties. Those tables have a large amount o...
Thank you. Unfortunately, SQL server is not an option for us.
However, the following approach solved my problem:
- Create a new query
- Define the OData query as needed, instead of navigating from the top of the orgnisation:
= OData.Feed("https://org.api.crm.dynamics.com/api/data/v9.1/accounts?$select=accountid,name", null, [Implementation="2.0"])
