Connect to data in a Common Data Service managed data lake


Effective November 2020:

  • Common Data Service has been renamed to Microsoft Dataverse. Learn more
  • Some terminology in Microsoft Dataverse has been updated. For example, entity is now table and field is now column. Learn more

This article will be updated soon to reflect the latest terminology.

This article provides information on how existing Dynamics 365 customers can quickly connect to their analytical entities in the Common Data Service managed lake. You must be an admin on the Common Data Service organization to proceed and see the list of entities available in the managed lake.

Important considerations

Data stored in online services, such as Azure Data Lake Storage, may be stored in a different location than where data is processed or stored in Dynamics 365 Customer Insights. By importing or connecting to data stored in online services, you agree that data can be transferred to and stored with Dynamics 365 Customer Insights. Learn more at the Microsoft Trust Center.

Connect to a Common Data Service managed lake

  1. In audience insights, go to Data > Data sources.

  2. Select Add data source.

  3. Select Connect to Common Data Service and select Next.

  4. Enter a Name for the data source and select Next. Name guidelines:

    • Start with a letter.
    • Use letters and numbers only. Special characters and spaces are not allowed.
    • Use between 3 and 64 characters.
  5. Provide the Server address for your Common Data Service organization, and select Sign in.

    Dialog box to enter Common Data Service server address

  6. Select the entities you want to ingest from the available list.


    If some entities are already selected, they might be used by other Dynamics 365 applications (such as Dynamics 365 Sales Insights or Customer Service Insights). You can't change the selection. These entities will be available once the data source is created.

    Dialog box showing a list of entities in the Common Data Service org

  7. Save your selection to start syncing the selected entities to the Common Data Service managed lake. You'll find the newly added connection on the Data sources page. It will be queued for refresh and show the entities count as 0 until all the entities are synced.

Only one data source of an environment can simultaneously use the same Common Data Service managed lake.

Edit a Common Data Service managed lake data source

You only edit the entity selection after creating the data source. For example, if additional entities were added to Common Data Service and you want to import them too.
To connect to a different Common Data Service, create a new data source.

  1. In audience insights, go to Data > Data sources.

  2. Next to the data source you'd like to update, select the ellipsis.

  3. Select the Edit option from the list.

  4. Select additional entities from the available list of entities and select Save.


Can you tell us about your documentation language preferences? Take a short survey.

The survey will take about seven minutes. No personal data is collected (privacy statement).