Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a below table with columns source_table and source_id. This table is connected to other tables using source_id.
Now, I am trying to find the best way to create relationship between these tables. We tried to unpivot the 'source_table' & 'source_id' column like below:
As a result of this, there are multiple relationship coming to communication table and our relationship looks like below:
Is there any possibility that we can split the table into small tables to create relationship?
Please can you suggest some efficient ways to create relationships between tables?
Please let me know if you need further info!
Thanks in advance!
@Greg_Deckler @Ahmedx @Ashish_Mathur @grantsamborn @amitchandak
Solved! Go to Solution.
Hello @sivarajan21 ,
I suggest you take a look at the star schema Data Model.
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 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
Hey @sivarajan21
To efficiently manage tables and their relationship, you can create a star schema with one center table having numerical values and related with different dimension tables having categorical values.
you can refer below link to learn more about star schema
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If you found this useful then please mark my solution as accepted so that others can find it quickly while facing similar issue. Thank You!
Hi Guys,
Thanks for helping out!
Hey @sivarajan21
To efficiently manage tables and their relationship, you can create a star schema with one center table having numerical values and related with different dimension tables having categorical values.
you can refer below link to learn more about star schema
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If you found this useful then please mark my solution as accepted so that others can find it quickly while facing similar issue. Thank You!
Hello @sivarajan21 ,
I suggest you take a look at the star schema Data Model.
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 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |