Artificial Intelligence with Microsoft Power BI by Jen Stirrup & Thomas J. Weinandy

Author:Jen Stirrup & Thomas J. Weinandy [Jen Stirrup]
Language: eng
Format: epub
Publisher: O'Reilly Media, Inc.
Published: 2024-04-25T00:00:00+00:00

Once the relationship is in place, we can now remove the Country Name and Country Code columns by selecting them, and then right-clicking on the columns to choose the Remove Columns option:

We can see that there are only three columns of data now. Power BI can use the relationship between the tables as a lookup to retrieve the Country Code or Country Name information as required:

And here:

To commit the change to Power BI, choose the Close and Apply button.

We can then check that the data model relationships are set up properly. To do this, navigate to the Model canvas in Power BI. It can be reached by clicking the Model button on the left-hand side of the Power BI Desktop, and it is the third button in the vertical pane at the very left-most side of the screen:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.