None Conformed Dimensions

Obviously you can put together a table from

Year month (From Time) AccountCode (FromAccount) Category (From Product) Volume (From f Sales)

No problems

You can put together a table

Year month (From Time) AccountCode (FromAccount) Visit Status (From visit) NoOfVisits (From f Visits)

No problems

Try and put everything together in one table and it cant be done 'Cant Determine Relationships between the fields'

This is because of Product information in the table. Remove Product and its fine

How would you go about resolving this in by changing the model. This is none conformed Dimensions over in Oracle

(From Time)  (FromAccount) (From Product)    (From f Sales)         (From visit)        (From f Visits)

Year month  AccountCode    Category              Volume                 Visit Status       NoOfVisits

As an extra. I thought merge might be the answer, Merge Product factory into my f sales table specifically for this issue

My thought was, I could use Product category in the fact table for this specific issue.

However when i recreated the table

(From Time)  (FromAccount) (From f Sales merge)    (From f Sales)         (From visit)        (From f Visits)

Year month  AccountCode    Category                       Volume                 Visit Status       NoOfVisits

I still get the error message

'cant display the data because Power BI cant determine the relationship between two or more fields'

So my merge idea hasnt worked and Im a bit stumped