Unable to add a new column to excel data souce

[Turquesa]

I have recently "inherited" a Power BI report at work and I have been tasked with adding a new column to the report in Power BI (it has already been added to the excel source). I get an error message when I try to refresh the Power BI (column 47 wasn't found).

I believe the Power BI I inherited already had some expression error because when I look at the applied steps it says "Expression Error: The Column 47 of the report wasn't found". When I looked at the excel source in more detail I noticed that the heading is blan but there is some data in the column. I then tried to add the new column in column 48 but I got the same error message. 

I would really appreciate if you could help me with this issue as I am fairly new to Power Bi. I tried to find in the Advanced Editor the number of columns (this is how I have added new columns in the past) but there is no specific reference to columns in the code.

Thanks in advance!

[Turquesa]

Hi @Idrissshatila! Thanks for your quick reply.

Yes, I can see the following applied steps looking at an earlier version of the Power BI (before I tried to add the new column).

Changed Type: Expression Error. The column 47 of the table wasn't found

= Table.TransfromColumnTypes......................................("Column47,type any), ("Column48", type any)

Renamed Column: Table.RenameColumns(#"Changed Type",{{"Column47", "Correction number"}})

Removed Columns: Table.RemoveColumns(#"Renamed Columns",{"Column48"})

How can I fix this and add new columns?

[Idrissshatila]

@Turquesa ,

remove the column 47 from every step in the applied steps

[Turquesa]

@Idrissshatila How do I do this?

[Idrissshatila]

@Turquesa , 

you can either remove the steps and recreate them again, or adjust the m code in the advanced editor to and remove the everything related to the missing row from this

= Table.TransfromColumnTypes......................................("Column47,type any), ("Column48", type any)

Renamed Column: Table.RenameColumns(#"Changed Type",{{"Column47", "Correction number"}})

Removed Columns: Table.RemoveColumns(#"Renamed Columns",{"Column48"})

[Idrissshatila · Accepted solution]

Hello @Turquesa ,

in power query, check where the error is coming from, in which step, the missing column should be referenced in a step, check if it is referenced in change type.