cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wech747
Frequent Visitor

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 the Excel spreadsheet and just wanted to synchronize the dashboard in Power BI again, when I get an expression error, which says, that the column 'cars' can not be found.

Is there any way to change the column name of my in Power BI imported data, so that it finds the renamed column again?
Or do i really have to create a whole new dashboard because of this?

I would be very grateful about an answer.

 

Kind regards

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Synchronisation error after renaming column in source file

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. 


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

Re: Synchronisation error after renaming column in source file

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. 


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

wech747
Frequent Visitor

Re: Synchronisation error after renaming column in source file

Hi smoupre,

 

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

Kind regards

chaichatp Helper II
Helper II

Re: Synchronisation error after renaming column in source file

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.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors