How to link multiple data sources to two master sources?

[dcheng029]

Hi everyone,

I am working with a total of 9 data sources (7 are normal data sources and 2 are master data sources which links the normal ones together).

I would like to create several filters whereby the dashboard can filter using some of the "Employee Listing" information AS WELL as a date filter.

I have tried to map the relationships on PBI Desktop starting with the Employee Listing master source with no issues. However when I try to add the Date linkages the error message "There are ambiguous paths between 'Source 4 and 'Date': 'Source 4'->'Employee Listing'->'Source 2'->'Date' and 'Source 4->'Employee Listing'->'Source 1'->'Date'."

My question is how do I map the relationships so Sources 1-7 are connected by both the Date source and Employee Listing source?

I have created the below photo that visualises what I would like to achieve, thanks in advance.

[Idrissshatila]

Hello @dcheng029 ,

in order to achieve what you want you need to create dimension tables that would link the tables you want to connect.

you need to implement the concept of star schema modeling, check it out https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

[dcheng029]

Hi @Idrissshatila,

Thank you for the guidance on this one!

My main struggle is getting the dates to talk to each other across all the sources so if I was to add a date slicer all the visuals across all the sources would appropriately filter.

Looking at the article you provided, my fact table "Employee Listing" does not have any date data. I have repositioned my model map so it's easier to interpret; what should I be implementing to have the dates relate to each other?