Public preview of Common Data Model, a Core component of Dynamics 365 is now available

When Microsoft Dynamics 365 was announced last month at WPC 2016, the Common Data Model was one of the core components of this new Cloud business solution offerings from Microsoft. I also explained in brief about the Common Data Model and the role it plays in Dynamics 365, in my earlier post.


Yesterday (8th August 2016), Microsoft announced the Public Preview of the Common Data Model and it’s integration with Microsoft Flow and PowerApps, which are  new cloud services from Microsoft ,that creates automated workflows between apps and services (such as collecting and creating data, synchronizing files or even getting notifications) and creating intelligent business apps respectively. Refer to the blog post below.

The Common Data Model and what you can do with it using Microsoft Flow, Power Apps, Power BI and more for your CRM and ERP (Dynamics AX / Project Madeira) data are very promising.

You can start exploring the Common Data Model and start thinking of apps and flows that you can build using this.

To see and explore some the entities of the CDM, log in to Microsoft Power apps at You can use your Office365 credentials for this.

Expand the Manage Tab > Entities. If you are doing it for the first time, click Create my database button. You will now be able to see several out of the box entities such as Customers, Employees, Contractors, Products and more (As you know them in Dynamics AX already). In this I have already created my database for the CDM which looks as shown in screenshot below.

Power Apps CDM

For instance, you can select the Employee, Customer or Products entity and see all the data fields that are part of it. You can further open them in excel and play around the demo data (Contoso) using Power Apps office add in (Very similar to the Dynamics Add in we all are used to in the New Dynamics AX

Entity Details

As an example, I have opened the Customer master in Excel and you can see we have the familiar Contoso data in it:)

Open in Excel

Just a beginning !! keep exploring and stay tuned for future posts.  You can also check out the Dynamics 365 page on SBS Group’s website for additional info.



Sandeep ChaudhurySandeep Chaudhury is a Dynamics AX enthusiast with over 10 years of experience in functional consulting, Solutions architecture and systems integration, with expertise in the areas of Professional services automation(Project Management and accounting), Financials Management, Services Management, Sales and Marketing, Human resource management, Travel and Expenses Management and Procurement & Sourcing modules of Microsoft dynamics AX ERP. He has experience working with the new Dynamics AX (AX 7), AX 2012 R3, AX 2012 R2 and more.