Forum Discussion
Rename table without killing everything
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)
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.
9 Replies
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/Im only wanting to change in Power Query, but I have changed column headers before and its broken everything
100% it won't destroy if you are chnaging in Power query.
Let me know when you have tried earlier ?
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
Sorry guys, I didn't actually create the table in Power Query. Can I still change the table name???
what is your source ?
Connection type live or import ?
Where you want to change your table name ? In source or Power Query screen ?
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.
