Change Table Name Before Import New Source

[tecumseh]

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

[tecumseh]

@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]

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

[tecumseh · Accepted solution]

@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

[lbendlin]

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