In this article, we will walk you through the step by step guide of how to manage and delete a relationships in power bi.
Step 1: “Load a Dataset”
If you want to load your dataset, simply click on the “Get Data” button in the data group on the “Home Tab”. once you click on that it will show a drop-down menu with multiple data sources, select “Excel workbook” from there and click on that.
Once, you click on that it brings another dialog box, where you can pull your data file from your local system, select your file and click on “Open” button located at the bottom right corner of the dialog box.
Once, you are done with that it will bring a navigator dialog box, from there you can select your sheet from the left hand side and after that, simply click on the “Check Box” and select your “All” sheet. once you select, than click on “Load” button located at the bottom right corner of the dialog box for saving your changes.
Step 2: “Create Relationships Between Tables”
To create a relationship between two tables simply, click on the “Manage relationships” button in the modeling tab on the ribbon.
Step 3: “Review Your Data Table”
In the “Data” view, you will see all the tables you have loaded. Review the tables and ensure they are structured correctly. The tables should have a column that uniquely identifies each row and the column names should be meaningful.
Step 4: “Add a Relationship”
In the “Manage Relationships” dialog box, click on the “New” button to add a new relationship.
Once, you are make your relationship with your desire column and suddenly you realize that you made some mistake while making, so all you have to do is simply, right click on your relationship connection and you will see there was a option named as “Delete” click on that.
Once, you click on that it will show a confirmation dialog box and in there it will ask from you, that “Are you sure you want to delete this relationship”. if you are agree with that, click on “Yes” button.
Conclusion:
we will exploring the concepts of manage and delete relationships in power bi and along with that we also understanding why it should be necessary to delete this relationships.
