dimensional model

[Anonymous]

Hi, 

Can anyone advice on the below my query .

We are looking to add some new tables to our Semantic model in our work, we have alreay some tables like policy, lead, date tables and looing to add some new table of SMS Meaasges of Outbound and Inbound text measges to analyse the stuff.

see below ERD of database of this new tables

we have alreay buid semantic model and we are adding some new Dimension and fact table for this SMS text meassge, below is some proposed guidelines here: 

can anyone guide please is this the right approach for this or any suggetion.

[Syndicate_Admin]

Power BI will not allow you to have multiple path relationships. Either drop some of them or make them inactive.

[Anonymous]

ERD in the image is the Source database.... we are trying to build the model from this tables