Forum Discussion
bartvana
Sep 05, 2021Iron Contributor
Change name of Power Pivot table created with Power Query
I added a table ("Parameters") to the Data Model using a Power Query (with the option "add to data model" checked in the "Load To" options"). Due to circumstances (see "Details" below) it's called "P...
- Sep 05, 2021
To my knowledge you can't rename such table. If you rename the query, table in data model will be replaced, not renamed. It means you lost all data model customizations.
Yea_So
Sep 06, 2021Bronze Contributor
SergeiBaklan is correct, the relationships will be broken, therefore if you change it you will have to re-establish the relationships (basically re-creating it.
- SergeiBaklanSep 06, 2021Diamond Contributor
More exactly, not only relationships, all related to this table objects, includes measures. Actually table with old name is removed from data model, table with another name is added as new one.