![]() ![]() Once the relationships have been checked and completed, the data model in Power BI is ready, and we can take advantage of the relationships when we create visualizations and custom measurements. For example, in the screenshot below, the Sales table is being related to the Calendar table through a many to one relationship. In the Edit relationship dialog, we can select the tables that we want to create the relationship between. To do this, click on the Model tab in Power BI and then Manage relationships. It’s important that we check the relationships that Power BI has automatically created (in case some are incorrect). In the process of importing the data from the data source, Power BI attempts to identify the relationships in the tables. In the step-by-step instruction, the second step was to check the data model once we’d created the connection to our data source (SQL Server) and imported the data. Let’s go back to the earlier example in Power BI.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |