Things to watch out for when configuring the export of CDS data to Azure Data Lake

End October 2019 Microsoft announced general availability of the export to Azure Data Lake functionality  (previously called Project Athena) for CDS and Dynamics 365 (Sales, Customer Service and Field Service).

It is quite easy to setup by following the steps outlined in the announcement blog post  or the official documentation on exporting entity data to Azure Data Lake Storage Gen2 - there are however two important prerequisites:

• The Azure storage account must be created in the same Azure AD tenant as your CDS/Dynamics 365 tenant (See subscriptions, licenses, accounts, and tenants for Microsoft's Cloud Offering if you are not familiar to these concepts) and the storage account must be created in the same Azure region (See Data center regions for Power Platform for more details) Fortunately the configuration screen provides these details as well - if the subscription drop down is empty, you probably did not meet one of the above requirements

• The login that you use to configure the Export to Data Lake settings needs to be an owner of the Azure storage account. If you missed this step you will get an exception in the configuration wizard on the second screen.

References:

• The Common Data in Azure Data Lake Storage - Export to Data Lake
• Publish CDM folder as REST endpoints
• Azure Data Lake with Dynamics 365 FinOps - Customer Insights and the Power Platform