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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
mckinleyp
Frequent Visitor

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 relationships I can create between the tables but the only one that seems to make the most sense is on transaction number. 

the issue is that one table contains all transaction numbers and has extra info attached while the other table has just one type of transaction number and no extra info 

 

any help on how I could connect these two would be appreciated. 

 

**note these are live models and I cannot use power query 

mckinleyp_0-1734555609980.png

 

3 REPLIES 3
lbendlin
Super User
Super User

 the only one that seems to make the most sense is on transaction number. 

DANGER DANGER DANGER

 

transaction numbers tend to have extremely high cardinality.  Anything above 50000 will result in catastrophic performance as the cross-semantic model queries (the queries, not the data!) will end up being multiple gigabytes due to the enumeration of the join column.  Very highly NOT recommended.

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) 

mckinleyp_0-1734617116353.png

 

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.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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