- On the left side options column expand Data Sources – Bulk Sources – Query.
- On the Query Data Sources page, click the Create Bulk Query button.
- On the New Query Data Source page, click the Dynamics 365 Customer Engagement Query Data Source button.
- Name – enter a description for the data source.
- Connection – select the connection to be used from the dropdown list.
- Organization – after the connection is selected, the Organization field becomes active. Select the organization to be used from the dropdown list.
- Return Option Set Labels – Option sets within CRM have a value (held in the database) and a label (shown to the end user). Default queries to CRM return the value for option sets rather than the label. The return option sets as label checkbox on CRM data sources will return the label linked to the option set instead of the value.
- Click the Validate button – this will verify the Connection is successful.
- Edit Query – opens the Query Builder to edit the query.
- After the query has been created click on Next to return to the Dynamics 365 Customer Engagement Query Data Source window.
- Preview – preview the first 5 rows from D365
- Save – save the query data source