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.