 Hey guys welcome to SSUnitech, so see this side and this is continuation of Power BI tutorial. So today we are going to see about the managing relationships. In the last video of this video series we have seen about the relationships and it's time to manage that. So go to on the Power BI desktop and where we will see. So this is our project that we are currently working on. First move to on model view and inside the model view as you can see in the top you can see the manage relationships. Now we can click on this. So here we have already created the relationship between the country's final table and with the address table. Here in the bottom you can see four options are available. First is new, second is auto detect then edit and then delete. So auto detect option can be enabled in the Power BI desktop so go to on the file and in the file now go to on the option and setting and here go to on the options. In the options you will see a lot of options. So here we can see data load and many more. So here we can see the data load for current file. Here in the top as you can see auto detect new relationship after data is loaded. So as of now I have unchecked this check box that's why we did not get the relationship by default. So if you want to auto detect the relationship then you can directly select this check box and once you will load the data from the query editor to Power BI desktop then it will auto detect the relationships. So here what we want to do now our next target is we want to create the relationship between the product and country sales final table and we can also create the relationship between DIMM customer. So go to on the manage relationships and here we need to wait few seconds and here click on the new relationship. Once we click on the new relationship then we need to select the first table so as I told you country sales final table and what is the second table so we want to create the relationship on the DIMM customer. Here we have customer ID so we can select this one and here we can see the customer ID so that is good and here we can see menu to one and single make this relationship active. So we will discuss later on this video series as of now just click on OK. So it will create one more relationship between the country sales final table and DIMM customer. Now click on the new and this time I want to create the relationship with the final table and the product table. So here we have DIMM product here we can see the product ID and the product ID now we can click on OK. So it is added one more relationship. So here we can see the edit option if we want to make any change on this relationship then we can click on the edit and here we can change the columns if we have mapped wrong and in the delete relationship it will delete the selected relationship. As of now we can see the selected last one if we click on the delete so it will delete that one. It will ask and if you will click on the delete it will delete that one but I am not going to delete it. Now we can close it and here we have created the relationship with the country sales final table with the DIMM address as we have created in the last video in this video we have created the relationship with the DIMM customer and we have also created the relationship with the product table. So you can see we need to arrange it little bit after that it will be visible. So we can put it on the right side now you can see we have created these two relationships and the relationship is one to many so that looks good. So here I have explained about how you can manage the relationship and how you can enable the auto detect option for the relationship. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much guys see you in the next video.