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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ttleonard
New Member

Power BI doesnt refresh when a new column is added

Hi everyone,

I added column D in an Excel sheet.

ttleonard_1-1700578972578.png

Power BI shows an error

ttleonard_2-1700579014818.png

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

ttleonard_3-1700579050698.png

 

Could you please advise the solution? 

Thank you

Trang Leonard

5 REPLIES 5
ttleonard
New Member

Hi everyone,

Can anyone kindly assist me with my question? 

Thanks

Trang

amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

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.

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.