Rename table without killing everything

[richardmayo]

I need to rename by date table (because I was stupid and didn't name it properly)

Can this be done without completely destroying every report/dashboard that uses a column/measure from the date table (which is basically everything)

[v-juanli-msft · Accepted solution]

Hi @richardmayo 

As tested, if i create a date table via Modeling->New Table, enter DAX formula below:

date = ADDCOLUMNS(CALENDARAUTO(),"year",YEAR([Date]),"month",MONTH([Date]),"week",WEEKNUM([Date],2))

Add [Date] column from "date" table to the visual, then i rename the [Date] as [ss] or rename the "date" table' name, the visual would not break, it shows normally as before.

It is still working for measures which use columns from date table.

If i create a date table via Edit Queries->New blank query,

then i get a table called "new query", the date column is called "Column1",

Close&&Apply to the report view, i add the "Column1" into the line chart,

then i go back to Edit queries, double click on the "Column1" header and rename it as "Date",

rename "new query" as "date table2",

close&&apply, return to report view, chart works smoothly as before.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[richardmayo]

Sorry guys, I didn't actually create the table in Power Query. Can I still change the table name???

[Baskar]

what is your source ?

Connection type live or import ?

Where you want to change your table name ? In source or Power Query screen ?

[amitchandak]

If you have created some new columns using a table. There are chances that those do not get renamed when you rename the table in power bi

[Baskar]

Dear Friend, 

Where you want to rename it ?

If suppose you want to rename in your source system like SQL,Oracle. It will destroy you report.

Suppose you want to rename in Power Query modelling in Power BI no worries .

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

http://powerbi.baskarbiconsultant.com/

[richardmayo]

Im only wanting to change in Power Query, but I have changed column headers before and its broken everything

[amitchandak]

Check for the yellow triangle with ! mark, those are the broken ones.  The same icon when we create a wrong formula in measure or in the calculated column.  You need to fix them If they are created on power query. Just click on the name, it should allow you to edit

[Baskar]

Really intresting my friend.  Can you please share the attachment here.

[Baskar]

100% it won't destroy if you are chnaging in Power query.

Let me know when you have tried earlier ?