Connect Microsoft Dynamics 365 to AI, Sheets, Databases & BI Tools

Windsor.ai's Microsoft Dynamics 365 connector extracts your Microsoft Dynamics 365 data and syncs it to AI assistants like ChatGPT, Claude and Gemini, spreadsheets like Google Sheets and Excel, data warehouses like BigQuery, Snowflake and PostgreSQL, and BI tools like Looker Studio, Power BI and Tableau. Setup takes a few minutes in the browser, no coding required, and you can start for free, no credit card required.

How to connect Microsoft Dynamics 365 to Windsor.ai

  1. Create your free Windsor.ai account or log in.
  2. Select Microsoft Dynamics 365 and grant Windsor.ai access to your Microsoft Dynamics 365 data.
  3. Pick the fields and date range you need and preview the data.
  4. Choose a destination and start syncing your Microsoft Dynamics 365 data.

Microsoft Dynamics 365 fields

Windsor.ai's Microsoft Dynamics 365 connector offers 2,167 fields, organized in 66 tables such as accounts, bulkoperations, campaigns, campaignactivities, campaignresponses, competitors, contacts, discounts, discounttypes, dynamicpropertyinstances, goalrollupqueries, goals. Here are 30 of them:

  • Account - Accountid (accounts_accountid): Account - Accountid
  • Date (date): The Date
  • Account Name (account_name): The account name
  • Campaign (campaign): The Campaign Name
  • Account ID (account_id): The account ID
  • Account - Accountcategorycode (accounts_accountcategorycode): Account - Accountcategorycode
  • Bulkoperation - Bulkoperationnumber (bulkoperations_bulkoperationnumber): Bulkoperation - Bulkoperationnumber
  • Campaignactivity - Actualcost (campaignactivities_actualcost): Campaignactivity - Actualcost
  • Campaignresponse - Category (campaignresponses_category): Campaignresponse - Category
  • Campaign - Actualend (campaigns_actualend): Campaign - Actualend
  • Competitor - Address1_addressid (competitors_address1_addressid): Competitor - Address1_addressid
  • Contact - Accountrolecode (contacts_accountrolecode): Contact - Accountrolecode
  • Discount - Amount (discounts_amount): Discount - Amount
  • Discounttype - Createdon (discounttypes_createdon): Discounttype - Createdon
  • Dynamicpropertyinstance - Createdon (dynamicpropertyinstances_createdon): Dynamicpropertyinstance - Createdon
  • Goalrollupquery - Createdon (goalrollupqueries_createdon): Goalrollupquery - Createdon
  • Goal - Actualdecimal (goals_actualdecimal): Goal - Actualdecimal
  • Invoicedetail - Actualdeliveryon (invoicedetails_actualdeliveryon): Invoicedetail - Actualdeliveryon
  • Invoice - Billto_city (invoices_billto_city): Invoice - Billto_city
  • Leadaddress - Addressnumber (leadaddresses_addressnumber): Leadaddress - Addressnumber
  • Lead - Address1_addressid (leads_address1_addressid): Lead - Address1_addressid
  • Leadtoopportunitysalesprocess - Activestagestartedon (leadtoopportunitysalesprocesses_activestagestartedon): Leadtoopportunitysalesprocess - Activestagestartedon
  • List - Cost (lists_cost): List - Cost
  • Metric - Amountdatatype (metrics_amountdatatype): Metric - Amountdatatype
  • Msdyn_assignmentmap - Createdon (msdyn_assignmentmaps_createdon): Msdyn_assignmentmap - Createdon
  • Msdyn_assignmentrule - Createdon (msdyn_assignmentrules_createdon): Msdyn_assignmentrule - Createdon
  • Msdyn_attribute - Createdon (msdyn_attribute_createdon): Msdyn_attribute - Createdon
  • Msdyn_attributevalue - Createdon (msdyn_attributevalues_createdon): Msdyn_attributevalue - Createdon
  • Msdyn_callablecontext - Createdon (msdyn_callablecontexts_createdon): Msdyn_callablecontext - Createdon
  • Msdyn_conversationactionitem - Createdon (msdyn_conversationactionitems_createdon): Msdyn_conversationactionitem - Createdon

Use Microsoft Dynamics 365 data in ChatGPT and Claude

Windsor.ai is available as a plugin in ChatGPT and as a connector in Claude. Once Microsoft Dynamics 365 is connected to Windsor.ai, you can ask questions about your Microsoft Dynamics 365 data in plain language. Other MCP clients can add the Windsor MCP server at https://mcp.windsor.ai/.

Available destinations for your Microsoft Dynamics 365 data

AI assistants

ChatGPT, Claude, Copilot, Manus, Gemini, Gemini Enterprise, Perplexity, Cursor, Grok, Google Antigravity, Lovable, n8n, Base44, Mistral, Kimi, DeepSeek, AI Insights (any MCP client)

Spreadsheets

Google Sheets, Excel, Airtable

Databases & warehouses

BigQuery, Snowflake, MySQL, PostgreSQL, Supabase, Azure SQL, Redshift, Databricks, Microsoft Fabric, Windsor.ai Cloud Database, Cache Data Store

BI & dashboards

Data Studio, Power BI Desktop: Native, Power BI Desktop: Web, Tableau

File storage

Amazon S3 Storage, Azure Blob Storage

Code

Python/R Code

Popular connectors

Browse all 350+ connectors