Forum Discussion

tecumseh's avatar
tecumseh
Resolver III
2 years ago
Solved

Change Table Name Before Import New Source

Hi,

Using PBID updated through July, 2024
I'm about to import a new source I created in Snowflake.
Before I do that, I want to rename an old table from Table to zzzTable.
When I do that I get an error message about 1 relationship and then prompted to send error reporting to Microsoft which I did.

At this point, it would not let me change the name. It would not even let me change the name back to the original name.

The background of the name remained white and I could not do anything
I finally gave it a 3 finger salute and ended PBID in Task Mangler.

Any other ideas here or do I need to start from a clean slate?

Thanks,
-w

Need Help
  • tecumseh's avatar
    tecumseh
    2 years ago

    lbendlin 

    Thanks,

    Tables, Columns, Measures, Relationships exported using INFO functions in DAX Query View.
    I'll check a bit if can easily updated to new table name (All column names 100 % same) and import using C# Scripts in Tabular Editor 2 or 3.

    Thanks,

    -w

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Disconnect your old table before renaming it. Check if any measures refer to it.

  • tecumseh's avatar
    tecumseh
    Resolver III
    2 years ago

    lbendlin 

    Thanks,

    Yes several measures are based on the old table. I guess I expected the measures to adopt the new name, then I import the new table, find / replace zzzTable with Table.

    Is there a better approach?
    Thanks,

    -w

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Not really. Have fewer dependencies ? Make copies of your measure code so you can recreate them quickly ?

      • tecumseh's avatar
        tecumseh
        Resolver III
        2 years ago

        lbendlin 

        Thanks,

        Tables, Columns, Measures, Relationships exported using INFO functions in DAX Query View.
        I'll check a bit if can easily updated to new table name (All column names 100 % same) and import using C# Scripts in Tabular Editor 2 or 3.

        Thanks,

        -w