This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
I have two tables and I have tried to establis relationship between the two, but it is not working. What is the best way to establish relationship between two tables?
Solved! Go to Solution.
Hello @DamasMasyaga ,
There should be a common column between the two tables so you could do a relationship between them, like Customer ID from table 1 with customer ID with table 2.
Also you could work on your model to make it a starschema model view
check this link to learn more about starschema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hello @DamasMasyaga ,
There should be a common column between the two tables so you could do a relationship between them, like Customer ID from table 1 with customer ID with table 2.
Also you could work on your model to make it a starschema model view
check this link to learn more about starschema https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 27 | |
| 25 | |
| 23 | |
| 19 | |
| 14 |
| User | Count |
|---|---|
| 50 | |
| 45 | |
| 20 | |
| 18 | |
| 18 |