BeyondERP.Newsletter
Menu

Setup step on the Export Entity Store to Azure data lake page · System administration

Set up Export Entity Store to Azure data lake

A setup page, titled Data feeds parameters, where you manage the connection between the application and Microsoft cloud services so that business data is copied to an Azure Data Lake storage account.

Business process
Administer system features
Menu item
DataFeedsDataConnection
Main table
BIMeasurementParameters
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page, titled Data feeds parameters, where you manage the connection between the application and Microsoft cloud services so that business data is copied to an Azure Data Lake storage account.
What you do hereUse this page to enable Data Lake integration, enter the Azure Key Vault details (application ID, application secret, DNS name and secret name), and test the Azure Key Vault and Azure Storage connections.
ExampleFor example, before turning on Commerce product recommendations, BEAT enables Data Lake integration here, tests the Azure Key Vault and Azure Storage connections, and turns on Automatic Refresh Enabled for the RetailSales entry on Entity Store.
Export Entity Store to Azure data lake page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAdminister system features
Menu pathSystem administration › Setup › Export data to Azure data lake › Export Entity Store to Azure data lake
Set up firstKey Vault parameters Microsoft Learn
Used next byEntity Store (automatic refresh) Microsoft Learn
Related pagesExport to Data Lake (retired service under the same menu) Microsoft Learn
In this process Set up Export to Data Lake · Set up Monitoring and telemetry parameters
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Export Entity Store to Azure data lake1 screen
  1. Screen 1

    Review the data lake connection

    Go to System administration > Setup > Export data to Azure data lake > Export Entity Store to Azure data lake

    1. Review the Enable Data Lake integration and Trickle update Data Lake options
    2. Enter the Azure Key Vault application ID, application secret, DNS name and secret name
    3. Select Test Azure Key Vault and Test Azure Storage
    4. Select Save
    Review the data lake connection (zoomed on the outlined fields)
    Show the full screenReview the data lake connection
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to System administration > Setup > Export data to Azure data lake > Export Entity Store to Azure data lake.
  2. On the Data connections tab, set Enable Data Lake integration to Yes.
  3. Under Azure Key Vault, enter the Application ID, Application Secret, DNS name and Secret name.
  4. Select Test Azure Key Vault to test that connection.
  5. Select Test Azure Storage to test that connection.
  6. Select Save.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Enable Data Lake integrationTurns on the connection from the Entity store to your Azure Data Lake Storage Gen2 account.Microsoft Learn Yes
Application ID, Application Secret, DNS nameConnect to the Azure Key Vault that holds the storage secret.Microsoft Learn
Secret nameThe secret in Key Vault used to authenticate with Azure Data Lake Storage.Microsoft Learn
Test Azure Key Vault / Test Azure StorageCheck each connection; if a test fails, confirm the Key Vault information and test again.Microsoft Learn

Common errors and fixes

MessageWhat to do
Test Azure Key Vault or Test Azure Storage failsConfirm that all the Key Vault information (Application ID, Application Secret, DNS name, Secret name) is correct and test again. Microsoft Learn

Test checklist

  1. Set Enable Data Lake integration to Yes and enter the Key Vault details.
  2. Select Test Azure Key Vault and Test Azure Storage and check both succeed.
  3. On Entity Store, set Automatic Refresh Enabled to Yes for the needed measurement and select Refresh.
  4. Check that data files appear in the storage account.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Export Entity Store to Azure data lakeEnable Data Lake integration with the Key Vault Application ID, Application Secret, DNS Name and Secret name, and save only after Test Azure Key Vault and Test Azure Storage both succeedThe Key Vault details are needed to read the storage secret, and Learn has you test both connections before relying on the setup.Should the Entity store be mirrored to a data lake?Stopping after the connection tests: you must also turn on automatic refresh for the Entity store measurements that need to reach the data lake.Test: Entity store data reaches the data lake

Feature management and licence

Licence or add-inCommerce product recommendations, turned on in Feature management, need this connection. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
Can it be undoneReversible: The connection values can be changed and the tests rerun at any time.
If you change it laterAfter the connection is set up, all customer data in the environment's Entity store mirrors automatically to your Azure Data Lake Storage Gen2 account, and Commerce product recommendations use the same storage. Microsoft Learn
Technical architect

6Technical

Menu itemDataFeedsDataConnection Checked in Dynamics 365
FormDataFeedsDataConnection Checked in Dynamics 365
TableBIMeasurementParametersShown as “BI Parameters” in Record infoChecked in Dynamics 365
Who can open itPrivilegesData feeds security privilege DataFeedsModelSecurityPrivilegeDutiesData feeds security duty DataFeedsModelSecurityDutyChecked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=DataFeedsDataConnection
Data migrationLoad order: Export Entity Store to Azure data lake has no data entity in Data management, so it can't be loaded from a file or a configuration template. Enter the Key Vault details by hand in each environment and run both connection tests.Checked in Dynamics 365
Table definitionBIMeasurementParameters columns and relations Microsoft data model
Everyone

8Sources

To cite this step: SA-SETUP-380, Set up Export Entity Store to Azure data lake. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SA-SETUP-380