Forum Discussion

bartvana's avatar
bartvana
Iron Contributor
Sep 05, 2021
Solved

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...)

  • bartvana 

    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_So's avatar
    Yea_So
    Bronze Contributor

    bartvana 

     

    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.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor

      Yea_So 

      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.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    bartvana 

    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.

     

Resources