Source Excel sheet added new column - Expression.Error: The column 'x' of the table wasn't found.

[sjpaq]

I understand that power bi is missing that column in the table. But in going over the steps of the import (I used the wizard), I cannot find where the columns are created in Power BI. Below is a pic of the steps in the transformation. If someone can point out which step defines the columns, I think I can fix it.

[sjpaq · Accepted solution]

Thanks @amitchandak 

Here is the promote headers content. In the screen shot below, you can see the new column circled in black

Here is the final step in the Transformation (Changed Type) where I manually added the new column (circled in black below). This is the step causing the error

I removed the text that I added to the Changed Type section to define my new column ( {"IRTOperationName", type text}, ) clicked on apply/close and suddenly the refresh worked. So, problem solved, but not sure why. The Changed Type step defines the type of each column and I suppose I'm fine since the type of the new column is text but not sure what would happen if the type was a date or a numeric and needed to be defined.

[amitchandak]

@sjpaq , if you are missing a column, you have to check all the steps. But in your case, final columns are coming from Promote headers.

In this step, first row is used as header

[sjpaq]

I looked at the Advanced Editor the following is what it looks like. Still nowhere that I can see where the columns in the table are defined. See the column highlighted in yellow, this is the column that I added to the spreadsheet and now causing the error in the subject line of this post.

[amitchandak]

@sjpaq , Click on step 3 and check if there is any data on that