Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Jerome_C63
Frequent Visitor

Modified column header

Good morning to the Power BI community,

From the Excel files that I receive every week concerning incidents by department, I have built a Power BI report.
Sometimes, in the Excel files, the name of the department in the column header (e.g. Marketing) is modified by a person and therefore, during the refresh, I get an error during the transformation indicating that the "Marketing" column does not exist.

Currently, I manually check the column headers or I modify the transformation steps in Power Query Editor so that the refresh works.

I would like to know if there is any way to manage this type of problem in an automated way?

Thanks in advance

2 REPLIES 2
Jerome_C63
Frequent Visitor

Hi 1Daniel993

 

Sorry for the delay but I am full at the moment.
Yes, I normally have the same number of columns (hopefully the person who changes the header name doesn't add any more).

1Daniel993
Helper III
Helper III

Hello, you could try with code M in powerQuery

Questions always do you have the same numbers of columns?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.