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 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
4 Replies
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.
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/
