Relationship columns

[Anonymous]

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 records, can anyone help to understand this that what are these relationship columns are holding in them as when I expand these columns they expand into a full table the I. E. A related table, then can i expand a single table and use it as single data set instead of loading all related table and modeling them locally in power bi... Plz help

[VasTg]

@Anonymous 

Your ask is not clear.

If you don't want to model in power BI, create a single table with SQL and use that in Advanced options while connecting to SQL server.

[Anonymous]

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.

[v-xicai]

Hi @Anonymous ,

>>but i want to understand what these relationship columns hold in them, they are expanding into a full table, the related table.

For further analysis, could you please show us what the relationship columns look like in screenshot?

Best Regards,

Amy

[amitchandak]

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/