Forum Discussion
Creating a relationship between two live semantic models without access to Power Query
Hey there please see below I really need help on this one I need to join two semantic models as they contain data that really needs to be together in order to be useful. There are a couple of relat...
Thankyou for that! I was encoutering that kind of error. One thing I would note that one semantic model has key collums in each of their tables, would there be a way for me to replicate those keys in the other model? I cannot use power query or edit the data since it is live.
I am adding the below screenshot to add context
the right hand light blue tables are from a finance model and the lefthand darker blue are an inventory model. The goal is that I can combine them so I can see the location (warehouse) the transaction took place in and by which ledger account (located in finance model)
The only way to make this work is to NOT join them but to use measures and TREATAS to run very finely tuned queries across them.