New Upload weather data from web services into TM1/Planning Analytics — Read the post →

Model View

The Model View in Power BI Desktop provides a visual interface to manage relationships between data sets that helps understand and organize the data structure that we have loaded in the Power BI model. We will now recreate the data model relationships as per the TM1 sample model. Go to the Model View which is on the lefthand side panel as shown below:

image-20251017-080742.png

Feel free to rearrange the data/metadata blocks as shown below, take a look at the relationships that have been automatically defined when we loaded the data and metadata from the TM1 model. You will note that the relationship for the Version dimension is missing and that the relationship for the Expense accounts has been incorrectly defined.

image-20251017-080803.png

Let’s defined the relationship for the version dimension and any other dimension/set that was not automatically defined when loaded, follow the steps as shown below:

image-20251017-080856.png

You can also edit the relationships, for example, let’s edit the relationship for the Expense account as shown below:

image-20251017-080846.png