Creating Relationship between Workorder table and SLAKPIInstance for field service for Power BI purposes

Like (0) Share

Report

Posted on 16 Dec 2019 12:20:51 by Community Member

For dashboard purposes I wondering if it is possible to connect the table of workorders and the SLAKPI instances table from window dynamics 365 for the field service.

For anyone who has done this before, I am looking to create a data model in Power BI where I can use the Created on column on Work Orders table, and Succeed on column on SLAKPI instance for visual and calculation purposes.

All responses (1)

Answers (1)

Verified answer

ba365guy 2,948 on 16 Dec 2019 at 13:29:30

Like (1)

Report

RE: Creating Relationship between Workorder table and SLAKPIInstance for field service for Power BI purposes

Hi

Yes. Please follow the instructions in the below link.

https://docs.microsoft.com/en-us/dynamics365/field-service/sla-work-orders