Tables in a customer's Data Lake Storage Gen2 data lake


This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
End users by admins, makers, or analysts This feature is released. Sep 30, 2020 -

Business value

Exporting data to your own Azure SQL Database isn't needed when the data is readily available in your own data lake. This feature enables customers to reduce their reliance on Bring your own database (BYOD) functionality and to eventually retire the use of it.

Customers who upgrade from Dynamics AX 2009 and Dynamics AX 2012 who have their existing data warehouses integrated into an operational database can now upgrade to Finance and Operations apps with minimal disruptions to their existing integrations.

Feature details

Tables in the Finance and Operations apps are now available in your own Azure Data Lake. You can select the required tables while the system keeps the data refreshed on a near real-time basis. There is no need to monitor and manage export jobs or schedules. Power users and developers can use a variety of tools and languages to access data within their own Data Lake, including DataFlows, Spark, and SQL.


This feature is in limited preview and might not be available in all regions and environments supported by Finance and Operations apps. If you are unable to find the Export to Azure Data Lake functionality in Lifecycle Services (LCS) or your Finance and Operations apps, this feature is not currently available in your environment. Refer to documentation for availability information and to join previews.