Forum Discussion

wech747's avatar
wech747
Frequent Visitor
9 years ago
Solved

Synchronisation error after renaming column in source file

Hi,   i've created a dashboard in Power BI Desktop, the data source of it is an Excel spreadsheet. Due to a wrong named column I just had to rename this column (e.g. from 'cars' to 'vehicles') in ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Exact resolution is going to depend on your query but you will not have to recreate your report. Go into Query Editor. Go to Advanced Editor. Copy the text and paste into Notepad. Search for cars. Replace. Copy back to Advanced Editor. Save. 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Exact resolution is going to depend on your query but you will not have to recreate your report. Go into Query Editor. Go to Advanced Editor. Copy the text and paste into Notepad. Search for cars. Replace. Copy back to Advanced Editor. Save. 

  • wech747's avatar
    wech747
    Frequent Visitor
    9 years ago

    Hi smoupre,

     

    thank you very much four your advice. It works fine! :)

    Kind regards

  • chaichatp's avatar
    chaichatp
    Helper III
    8 years ago

    I have the same problem but I couldnt follow your guideliine. My steps was

    1. Rename column header in Excel then Save&Close file 

    2. Refresh power Bi

    3. I got yellow box error "Expression.Error: The column 'Previous Column Header Name' of the table wasn't found.

        Details: Previous Column Header Name

     

    Could you please tell me where to start your step? I tried to open Advanced Editor after I got error and find for "Previous Column Header Name" but nothing found. 

     

    Thank you.

  • CH_MJR79's avatar
    CH_MJR79
    Helper II
    3 years ago

    thanks Greg_Deckler  I know its a few years old but this just helped me.