Forum Discussion

jhowe1's avatar
jhowe1
Helper III
5 years ago
Solved

field service data model optimisation

Hi all,   We're using d 365 field service and i'm interested in producing a field service report in power bi. i've been looking at the microsoft template for this on github https://github.com/micro...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    jhowe1 - You're likely stuck with it. Dynamics database schemas are quite complex. The above looks VERY much simplified down from the underlying tables. It's really, for the most part, two star schemas (bit of snowflake in bottom right) built around Work Orders and Booked Resources from what I can tell with a bridge table between them. Not the end of the world in my opinion.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

jhowe1 - You're likely stuck with it. Dynamics database schemas are quite complex. The above looks VERY much simplified down from the underlying tables. It's really, for the most part, two star schemas (bit of snowflake in bottom right) built around Work Orders and Booked Resources from what I can tell with a bridge table between them. Not the end of the world in my opinion.

  • jhowe1's avatar
    jhowe1
    Helper III
    5 years ago

    Great thanks Greg_Deckler just wanted to get another opinion before using this as an inspiration/starting point for our model.