Power BI doesnt refresh when a new column is added

[ttleonard]

Hi everyone,

I added column D in an Excel sheet.

Power BI shows an error

Below are the steps I did to transform data before adding a new column.

Could you please advise the solution? 

Thank you

Trang Leonard

[ttleonard]

Hi everyone,

Can anyone kindly assist me with my question? 

Thanks

Trang

[amitchandak]

@ttleonard , seems like column 50 is not found, it has been used in the rename, or change type step, which is causing that.

Check the steps and remove the reference of the column

[ttleonard]

Can you kindly be more specific? Which step should I remove or modify? 

[tmhalila]

If you are still a beginner modifying steps in Power Query may cause more problems. What I see is that the addition of the new column is not the source of the refresh failure, please remove the last 2 steps and try to refresh, if it doesn't work delete another step until you find were the problem starts.

[lizzy]

Look in your "Change Type" step. It probably references a column by a name that it doesn't have anymore. The way in general to figure this out is click on each step one by one and see where the error begins.