Forum Discussion
Relationship columns
I have to develop a report on top of my sql database having a schema with1 fact table and many dimension tables, after loading the data sets, each data set also have column value value and table and r...
Hi.. Thanks for the reply, but i want to understand what these relationship columns hold in them, they are expanding into a full table, the related table.
Not Sure I got it completely.
But just like SQL/database. Power BI will have its own internal data model. If you take in Fact and Dimensions, you need to create a relation between them. Now relations are uni or bi directional. This will decide the behavior of joins.
Typically, when you select a column from a dim and fact the power BI will return a result based on those two datasets.
Refer
https://docs.microsoft.com/en-us/power-bi/desktop-storage-mode
Also refer - https://docs.microsoft.com/en-us/power-bi/guidance/