Overview

Sometimes the default naming of tables and fields in Cosmos may not align with the terms used within the business, or business users may want to see things named differently. This article covers how to rename tables, fields, and relationships in the Data Model.

Details

To rename tables, fields, or relationships in the Data Model, you will navigate to the Data Management section of the Cosmos Portal and check out the extension related to what you want to rename. 

Next, navigate to the Data Model section, go to the table, field, or extension that you wish to rename, and click the pencil icon on the right.

This will open the window where you will rename the item. Type in the name that you want the item to have and click the Rename button for the changes to be saved.

The same steps are taken to rename tables, fields, and relationships in the Data Model.

Once you are finished renaming the things that you want to change you will check in your extension and then click the Publish Pipeline button for the changes to be saved. Your users will then see these table, field, and relationship names updated in both the Cosmos Report Editor Excel add-in as well as in Power BI. 

Cosmos reports that are built in Excel will not be impacted by changing the names of the tables and fields and will continue to run as expected.

Due to how Power BI reads data from its data sources, if a table or field is renamed that is currently used in Power BI reports, those reports will need to be updated as Power BI will continue looking for the old name.