Forum Discussion

richardmayo's avatar
richardmayo
Icon for Helper II rankHelper II
6 years ago
Solved

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 ta...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

     

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
6 years ago

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's avatar
richardmayo
Icon for Helper II rankHelper II
6 years ago

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

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

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

    Let me know when you have tried earlier ?

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      Baskar
      Icon for Resident Rockstar rankResident Rockstar
      6 years ago

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