1 / 13

How To Create And Manage Relationship Between Tables In Power BI?

I hope you will like it. Firstly, I would like to thank all of you guys for encouraging me to write these kinds of blogs. I have already discussed Power BI in my previous blogs. Power BI is a very good and famous tool for creating reports and Dashboards in predicting future analysis also. The main reason for writing blogs on Power BI is that it’s easy and quick to generate report and dashboard based on row data and publish it to the web service so that other users can also view it globally.<br><br>https://www.loginworks.com/blogs/how-to-create-and-manage-relationship-between-tables-in-power-bi/

rotansharma
Download Presentation

How To Create And Manage Relationship Between Tables In Power BI?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Welcome To Loginworks Softwares

  2. How To Create And Manage Relationship Between Tables In Power BI?

  3. What is the relationship in Power BI?Let’s take an example of real life. In real life, relationship is a bonding between two or many persons that share their resources. Without having relationship, they don’t share their resources. Similarly, in Power BI Consulting relationships means the connection between two or many tables that share their columns with each other and based on these relationships we can extract the data from other tables as required.Why we need relationship in Power BI?Sometimes we need to fetch data from one table based on another table in that case if we don’t have the relationship between these tables then we can’t fetch the data and if we have already created the relation between them then we can easily fetch the required data. And also, based on the relationship we can set the filters on the data. So, it is best to make a relation between the desired table. A relationship between tables helps us to generate best insights based on the data. Sometimes Power BI itself detects the relationship between tables or generate the possible relationship.One of the best features of Power BI is an Auto-detect relationship. This feature makes work easy for us.

  4. Auto-Detect During Data loadingIn power BI while loading data from different sources it automatically detects or creates relationship between two or more tables. During this phase, it also sets Cardinality, Cross filter direction, and Active properties. Power BI checks the column names of every table to find out any potential relationship existence that makes difference if these kinds of relation exist then it automatically creates those relations and if not then it does not create any kind of relation between any tables. Below are the screenshots of automatically or manually creation of relationships in power BI.

  5. Create a relationship by using Auto-detect feature

  6. You can see in the above screenshot, there is an auto detect option. Just click on that button, after clicking the button you can see the screen where you can find if there is extra relation exist.

  7. Create relationship manually

  8. As you can see the highlighted area is the option. In these options, you need to select the new option to create a new relation. Below is the screenshot of the next window after clicking on the new option button.

  9. After selecting the tables you can see the preview as shown below.

  10. In the above screens, you can see both tables and there is highlighted column on both the tables named “id”. These are the columns between which we want to create a relationship. The relationship only exists when there are unique values in either of the tables. If not then we can’t create a relationship between these two tables. By default, Power BI set the cardinality, cross-filter direction properties. But if you want to change these values you can do it later also.

  11. Edit or Manage existing relationshipThis is the option where you can edit the existing relationship. There are three additional properties you can play with these. Below are these additional properties.CardinalityMany-to-one ( *:1)It implies that many columns in one table are connected to a column in other table and vice-versa.One-to-one (1:1)It implies that a single column of one table is connected with the single column of another table.ConclusionIn this article, I have shared the deep knowledge on how to create and manage relationships between two table. I hope you guys have understood all the concepts of the same. If you have any query related to this topic or any other please feel free to contact us. Keep learning.

  12. Thanks For Watching Connect With Source Url https://bit.ly/2TfiqO0 Contuct us: 434-608-0184

More Related