Export guide
How to export your Microsoft Dynamics 365 data
Last verified: 2026-10-09 · Menu names change between plans and versions; check the vendor documentation below, and we confirm exact steps with you once you qualify.
Short answer
Microsoft Dynamics 365 (CRM and ERP) holds opportunities, cases, orders and activity history. You run the export yourself, from the app or through its API, after removing personal and confidential details. Nothing leaves your company until you approve it.
Export from the app
Step 1
Access environment settings
Open the Power Platform Admin Center, select your environment, and navigate to Azure Synapse Link.
Step 2
Create data link
Click 'New link', connect your Azure Data Lake Storage account, and select the tables you wish to export.
Step 3
Start synchronization
Click Save to initiate the initial historical export and begin continuous synchronization to your Data Lake.
Step 4
Check the file before sharing
Open a sample of the export, confirm the date range and record count, and flag anything personal or confidential. Don't send anything yet — we review the package together first.
Export through the API
Step 1
Create a read-only key
In Azure Active Directory → App Registrations, create an API token or app with read-only scopes. Keep it inside your company; never send it to SourceX.
Step 2
Use Dataverse Web API
Retrieve historical records by querying the OData-based Web API (e.g., /api/data/v9.2/accounts) for the desired entities.
Step 3
Pull history in batches
Page through records by date range, respecting rate limits. Save raw JSON to your own storage. Large histories can take several days.
Plan limits and formats#
- Limits and formats depend on your plan and are confirmed with you after qualification.
What to leave out#
- Names, emails, phone numbers and addresses of customers and staff
- Passwords, API keys, tokens and other credentials
- Payment card and bank details
- Attachments you haven't reviewed (they often hold IDs or contracts)
- Records covered by client NDAs, privilege or contracts that limit reuse
- Anything you mark confidential, such as pricing or strategy
Terms to check first#
- Your content is usually yours, but plan terms can limit bulk export, API use or automated access.
- Check whether your plan includes the export or API features you need before starting.
- Respect API rate limits; large exports may need to run in batches over several days.
- Don't share admin logins. You run the export yourself, with our guidance.
Vendor documentation
What happens after the export
See what your Microsoft Dynamics 365 records are worth to AI buyers and how licensing works, step by step.
Read the Microsoft Dynamics 365 licensing guideRelated
See if your company qualifies
A short company assessment. No data uploads are needed.