Forum Discussion
Tutorial for data model relationships?
Hello
I have several tables and I want to use various columns from each of these tables. I build relationships based on the fields that contain common values.
However, when I start dropping fields in a table visual, the values are not displayed correctly. Particularly, some values are missing when they shouldn't.
Can you provide some guidance on how to build relationships to achieve what I want?
For example, what relationship parameters to use?
Also there is something that seems to be a major annoyance of PowerBI.
After I have built the data relationships, when I bring together two columns from different tables in a table visual, all the values are shown as expected. But when I put other columns from other tables inbetween, it seems the relationships are broken. Any advice on that please?
hi Anonymous
For the relationship in power bi model, you could refer to this document:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
Regards,
Lin
3 Replies
Anonymous , refer
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
https://www.youtube.com/watch?v=-4ybWQSRcOY
In this series I created dimension table from table
https://www.youtube.com/playlist?list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb
hi Anonymous
For the relationship in power bi model, you could refer to this document:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
Regards,
Lin
