Forum Discussion

Anonymous

Not applicable

6 years ago

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...

Tips and Tricks

Tutorial Requests

Memorable Member

6 years ago

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
Not applicable
6 years ago
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.
- amitchandak
  Super User
  6 years ago
  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/
- v-xicai
  Community Support
  6 years ago
  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