Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
jhowe1
Helper III
Helper III

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/microsoft/BusinessPlatformApps/tree/dev/Source/Apps/Microsoft/Released/Microsoft-... but found the data model to be quite large and complex which goes against all my DWH design knowledge around simple star schema design. Was wondering if anyone had any ideas to simplify this? Or am I basically stuck with this model due to complexity around multiple facts relating to each other i.e. work orders, bookings, product costs, service costs etc.? Any ideas/help would be greatly appreciated to simplify/optimise this.

 

Screenshot 2021-01-08 at 11.43.10.png

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

@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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.