Saturday, April 15, 2017

Dynamics 365 Field Service Data Model

In the previous post, I discussed how to build a Power BI data model for Dynamics 365 Field Service.
While writing that post, I searched the web and Microsoft sites for Entity Relationship Diagram (ERD) for Work Order and related entities. However, the search returned no results.
I used the metadata diagram tool to generate the following diagram for the Work Order (msdyn_workorder) and related entities. It can be expanded to include more entities as needed.
You can download the Visio diagram (.vsd) here.

No comments: