Forum Discussion
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 "Parameters 1" in Power Pivot. I now want to change the name in Power Pivot to "Parameters", but it says to change that in the Power Query. However, I can't find anywhere in the Power Query where to change the name of the table in the Data Model. Everywhere I look, it already says "Parameters".
Does anyone know where I can change this?
(Details:
I had a dynamic Excel table named "Parameters" which I added to Power Pivot using the Power Pivot option "Add to data model".
I then decided it would be better to add it to the data model via a Power Query, which I did. In the "Load to" options I checked "Add to data model".
I then had, logically, twice the same table in Power Pivot, one named "Parameters" and another "Parameters 1". I updated my DAX formulas to point to the new table ("Parameters 1"), and deleted the first table ("Parameters"). So far so good. But now I can't change the name of the table in Power Pivot...)
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.
4 Replies
- Yea_SoBronze 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.
- SergeiBaklanDiamond 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.
- SergeiBaklanDiamond Contributor
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.
- bartvanaIron Contributor
OK, thank you SergeiBaklan and Yea_So , good to know, so I don't waste time looking any further. Thanks for answering!